{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 33102 entries, 0 to 33101\n",
      "Data columns (total 49 columns):\n",
      "Unnamed: 0              33102 non-null int64\n",
      "Unnamed: 0.1            16484 non-null float64\n",
      "age                     33102 non-null int64\n",
      "assist                  33102 non-null int64\n",
      "avatar                  33102 non-null object\n",
      "birthday                33102 non-null object\n",
      "charaters               33102 non-null object\n",
      "contract_time           33102 non-null object\n",
      "create_time             33102 non-null int64\n",
      "create_type             33102 non-null int64\n",
      "flag                    33102 non-null int64\n",
      "games_played            33102 non-null int64\n",
      "goal                    33102 non-null int64\n",
      "habit_foot              33102 non-null object\n",
      "height                  33102 non-null object\n",
      "honors                  33102 non-null object\n",
      "id                      33102 non-null int64\n",
      "injury_history          33102 non-null object\n",
      "jersey_numbers          33102 non-null object\n",
      "join_time               33102 non-null object\n",
      "league                  15466 non-null object\n",
      "league_id               33102 non-null int64\n",
      "name                    33102 non-null object\n",
      "name_en                 32474 non-null object\n",
      "national_team           4098 non-null object\n",
      "national_team_id        33102 non-null int64\n",
      "nationality             32467 non-null object\n",
      "number                  33102 non-null int64\n",
      "playing_time            33102 non-null int64\n",
      "position                26031 non-null object\n",
      "position_performace     33102 non-null object\n",
      "read_card               7170 non-null object\n",
      "red_card                33102 non-null int64\n",
      "retired                 33102 non-null int64\n",
      "season_performace       33102 non-null object\n",
      "short_en                116 non-null object\n",
      "short_name              22797 non-null object\n",
      "single_match_records    33102 non-null object\n",
      "sports_type             33102 non-null int64\n",
      "sports_type_cat         33102 non-null int64\n",
      "team_id                 33102 non-null int64\n",
      "team_info               25932 non-null object\n",
      "team_name               32454 non-null object\n",
      "transfers               33102 non-null object\n",
      "update_time             33102 non-null int64\n",
      "value                   33102 non-null float64\n",
      "vs_teams                33102 non-null object\n",
      "weight                  33102 non-null object\n",
      "yellow_card             33102 non-null int64\n",
      "dtypes: float64(2), int64(20), object(27)\n",
      "memory usage: 12.4+ MB\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/shenxibo/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2785: DtypeWarning: Columns (35) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "data = pd.read_csv('0522data/data_all.csv')\n",
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'Unnamed: 0.1', 'age', 'assist', 'avatar', 'birthday',\n",
       "       'charaters', 'contract_time', 'create_time', 'create_type', 'flag',\n",
       "       'games_played', 'goal', 'habit_foot', 'height', 'honors', 'id',\n",
       "       'injury_history', 'jersey_numbers', 'join_time', 'league', 'league_id',\n",
       "       'name', 'name_en', 'national_team', 'national_team_id', 'nationality',\n",
       "       'number', 'playing_time', 'position', 'position_performace',\n",
       "       'read_card', 'red_card', 'retired', 'season_performace', 'short_en',\n",
       "       'short_name', 'single_match_records', 'sports_type', 'sports_type_cat',\n",
       "       'team_id', 'team_info', 'team_name', 'transfers', 'update_time',\n",
       "       'value', 'vs_teams', 'weight', 'yellow_card'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>assist</th>\n",
       "      <th>birthday</th>\n",
       "      <th>charaters</th>\n",
       "      <th>contract_time</th>\n",
       "      <th>create_time</th>\n",
       "      <th>create_type</th>\n",
       "      <th>flag</th>\n",
       "      <th>games_played</th>\n",
       "      <th>goal</th>\n",
       "      <th>...</th>\n",
       "      <th>sports_type_cat</th>\n",
       "      <th>team_id</th>\n",
       "      <th>team_info</th>\n",
       "      <th>team_name</th>\n",
       "      <th>transfers</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>vs_teams</th>\n",
       "      <th>weight</th>\n",
       "      <th>yellow_card</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23</td>\n",
       "      <td>12</td>\n",
       "      <td>1996-01-11</td>\n",
       "      <td>[]</td>\n",
       "      <td>2021-06-30 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>139</td>\n",
       "      <td>{'id': '139', 'name_cn': '曼城', 'name_en': 'Man...</td>\n",
       "      <td>曼城</td>\n",
       "      <td>[{'id': '17629', 'player_id': '1', 'from_team_...</td>\n",
       "      <td>0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>[{'id': '11101', 'vs_team_id': '147', 'vs_team...</td>\n",
       "      <td>75</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>29</td>\n",
       "      <td>14</td>\n",
       "      <td>1989-09-13</td>\n",
       "      <td>[]</td>\n",
       "      <td>2021-06-30 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>222</td>\n",
       "      <td>{'id': '222', 'name_cn': '拜仁慕尼黑', 'name_en': '...</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>[{'id': '37712', 'player_id': '2', 'from_team_...</td>\n",
       "      <td>0</td>\n",
       "      <td>5500.0</td>\n",
       "      <td>[{'id': '161200', 'vs_team_id': '223', 'vs_tea...</td>\n",
       "      <td>75</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>1990-11-06</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-06-30 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>199</td>\n",
       "      <td>{'id': '199', 'name_cn': '富勒姆', 'name_en': 'Fu...</td>\n",
       "      <td>富勒姆</td>\n",
       "      <td>[{'id': '8161', 'player_id': '3', 'from_team_i...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>[{'id': '16422', 'vs_team_id': '666', 'vs_team...</td>\n",
       "      <td>73</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1985-07-10</td>\n",
       "      <td>[]</td>\n",
       "      <td>2020-06-30 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>335</td>\n",
       "      <td>{'id': '335', 'name_cn': '斯图加特', 'name_en': 'V...</td>\n",
       "      <td>斯图加特</td>\n",
       "      <td>[{'id': '18626', 'player_id': '4', 'from_team_...</td>\n",
       "      <td>0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>[{'id': '14680', 'vs_team_id': '223', 'vs_team...</td>\n",
       "      <td>89</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>2</td>\n",
       "      <td>1985-06-04</td>\n",
       "      <td>[]</td>\n",
       "      <td>2020-01-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>2570</td>\n",
       "      <td>{'id': '2570', 'name_cn': '神户胜利船', 'name_en': ...</td>\n",
       "      <td>神户胜利船</td>\n",
       "      <td>[{'id': '172657', 'player_id': '5', 'from_team...</td>\n",
       "      <td>0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>[{'id': '1164341', 'vs_team_id': '582', 'vs_te...</td>\n",
       "      <td>80</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   age  assist    birthday charaters        contract_time  create_time  \\\n",
       "0   23      12  1996-01-11        []  2021-06-30 00:00:00            0   \n",
       "1   29      14  1989-09-13        []  2021-06-30 00:00:00            0   \n",
       "2   28       0  1990-11-06        []  2019-06-30 00:00:00            0   \n",
       "3   33       1  1985-07-10        []  2020-06-30 00:00:00            0   \n",
       "4   33       2  1985-06-04        []  2020-01-31 00:00:00            0   \n",
       "\n",
       "   create_type  flag  games_played  goal     ...     sports_type_cat team_id  \\\n",
       "0            0     1            30    10     ...                  10     139   \n",
       "1            0     1            28     8     ...                  10     222   \n",
       "2            0     1             0     0     ...                  10     199   \n",
       "3            0     1            16     8     ...                  10     335   \n",
       "4            0     1            11     3     ...                  10    2570   \n",
       "\n",
       "                                           team_info  team_name  \\\n",
       "0  {'id': '139', 'name_cn': '曼城', 'name_en': 'Man...         曼城   \n",
       "1  {'id': '222', 'name_cn': '拜仁慕尼黑', 'name_en': '...      拜仁慕尼黑   \n",
       "2  {'id': '199', 'name_cn': '富勒姆', 'name_en': 'Fu...        富勒姆   \n",
       "3  {'id': '335', 'name_cn': '斯图加特', 'name_en': 'V...       斯图加特   \n",
       "4  {'id': '2570', 'name_cn': '神户胜利船', 'name_en': ...      神户胜利船   \n",
       "\n",
       "                                           transfers update_time   value  \\\n",
       "0  [{'id': '17629', 'player_id': '1', 'from_team_...           0  7500.0   \n",
       "1  [{'id': '37712', 'player_id': '2', 'from_team_...           0  5500.0   \n",
       "2  [{'id': '8161', 'player_id': '3', 'from_team_i...           0     0.0   \n",
       "3  [{'id': '18626', 'player_id': '4', 'from_team_...           0   600.0   \n",
       "4  [{'id': '172657', 'player_id': '5', 'from_team...           0   800.0   \n",
       "\n",
       "                                            vs_teams  weight yellow_card  \n",
       "0  [{'id': '11101', 'vs_team_id': '147', 'vs_team...      75           4  \n",
       "1  [{'id': '161200', 'vs_team_id': '223', 'vs_tea...      75           4  \n",
       "2  [{'id': '16422', 'vs_team_id': '666', 'vs_team...      73           0  \n",
       "3  [{'id': '14680', 'vs_team_id': '223', 'vs_team...      89           3  \n",
       "4  [{'id': '1164341', 'vs_team_id': '582', 'vs_te...      80           5  \n",
       "\n",
       "[5 rows x 46 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#保留所需要的字段\n",
    "col = ['age', 'assist','birthday',\n",
    "       'charaters', 'contract_time', 'create_time', 'create_type', 'flag',\n",
    "       'games_played', 'goal', 'habit_foot', 'height', 'honors', 'id',\n",
    "       'injury_history', 'jersey_numbers', 'join_time', 'league', 'league_id',\n",
    "       'name', 'name_en', 'national_team', 'national_team_id', 'nationality',\n",
    "       'number', 'playing_time', 'position', 'position_performace',\n",
    "       'read_card', 'red_card', 'retired', 'season_performace', 'short_en',\n",
    "       'short_name', 'single_match_records', 'sports_type', 'sports_type_cat',\n",
    "       'team_id', 'team_info', 'team_name', 'transfers', 'update_time',\n",
    "       'value', 'vs_teams', 'weight', 'yellow_card']\n",
    "data = data[col]\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"751ad7e6fb0a4088b8ff70ca5d7666e5\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_751ad7e6fb0a4088b8ff70ca5d7666e5 = echarts.init(\n",
       "            document.getElementById('751ad7e6fb0a4088b8ff70ca5d7666e5'), 'white', {renderer: 'canvas'});\n",
       "        var option_751ad7e6fb0a4088b8ff70ca5d7666e5 = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u6570\\u91cf\",\n",
       "            \"data\": [\n",
       "                130,\n",
       "                3,\n",
       "                25,\n",
       "                215,\n",
       "                610,\n",
       "                1382,\n",
       "                2095,\n",
       "                2382,\n",
       "                2442,\n",
       "                2455,\n",
       "                2450,\n",
       "                2364,\n",
       "                2309,\n",
       "                2185,\n",
       "                2037,\n",
       "                1869,\n",
       "                1717,\n",
       "                1492,\n",
       "                1284,\n",
       "                1050,\n",
       "                776,\n",
       "                651,\n",
       "                425,\n",
       "                315,\n",
       "                181,\n",
       "                121,\n",
       "                58,\n",
       "                30,\n",
       "                23,\n",
       "                8,\n",
       "                8,\n",
       "                5,\n",
       "                2,\n",
       "                3\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u6570\\u91cf\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"\\u6570\\u91cf\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                0,\n",
       "                15,\n",
       "                16,\n",
       "                17,\n",
       "                18,\n",
       "                19,\n",
       "                20,\n",
       "                21,\n",
       "                22,\n",
       "                23,\n",
       "                24,\n",
       "                25,\n",
       "                26,\n",
       "                27,\n",
       "                28,\n",
       "                29,\n",
       "                30,\n",
       "                31,\n",
       "                32,\n",
       "                33,\n",
       "                34,\n",
       "                35,\n",
       "                36,\n",
       "                37,\n",
       "                38,\n",
       "                39,\n",
       "                40,\n",
       "                41,\n",
       "                42,\n",
       "                43,\n",
       "                44,\n",
       "                45,\n",
       "                46,\n",
       "                48\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6bcf\\u4e2a\\u5e74\\u9f84\\u7684\\u7403\\u5458\\u6570\\u91cf\\u5206\\u5e03\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "        chart_751ad7e6fb0a4088b8ff70ca5d7666e5.setOption(option_751ad7e6fb0a4088b8ff70ca5d7666e5);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x11db95748>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看所有球员的年龄分布\n",
    "agelist = data.groupby(by='age').count()['id']\n",
    "\n",
    "from pyecharts.charts import Bar\n",
    "from pyecharts import options as opts\n",
    "\n",
    "bar = (\n",
    "    Bar()\n",
    "    .add_xaxis(agelist.index.tolist())\n",
    "    .add_yaxis(\"数量\", agelist.values.tolist())\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"每个年龄的球员数量分布\"))\n",
    ")\n",
    "bar.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>assist</th>\n",
       "      <th>birthday</th>\n",
       "      <th>charaters</th>\n",
       "      <th>contract_time</th>\n",
       "      <th>create_time</th>\n",
       "      <th>create_type</th>\n",
       "      <th>flag</th>\n",
       "      <th>games_played</th>\n",
       "      <th>goal</th>\n",
       "      <th>habit_foot</th>\n",
       "      <th>height</th>\n",
       "      <th>honors</th>\n",
       "      <th>id</th>\n",
       "      <th>injury_history</th>\n",
       "      <th>jersey_numbers</th>\n",
       "      <th>join_time</th>\n",
       "      <th>league</th>\n",
       "      <th>league_id</th>\n",
       "      <th>name</th>\n",
       "      <th>name_en</th>\n",
       "      <th>national_team</th>\n",
       "      <th>national_team_id</th>\n",
       "      <th>nationality</th>\n",
       "      <th>number</th>\n",
       "      <th>playing_time</th>\n",
       "      <th>position</th>\n",
       "      <th>position_performace</th>\n",
       "      <th>read_card</th>\n",
       "      <th>red_card</th>\n",
       "      <th>retired</th>\n",
       "      <th>season_performace</th>\n",
       "      <th>short_en</th>\n",
       "      <th>short_name</th>\n",
       "      <th>single_match_records</th>\n",
       "      <th>sports_type</th>\n",
       "      <th>sports_type_cat</th>\n",
       "      <th>team_id</th>\n",
       "      <th>team_info</th>\n",
       "      <th>team_name</th>\n",
       "      <th>transfers</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>vs_teams</th>\n",
       "      <th>weight</th>\n",
       "      <th>yellow_card</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3262</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>1991-11-19</td>\n",
       "      <td>[]</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>{'最佳射手': {'honor': '最佳射手', 'logo': 'http://tu....</td>\n",
       "      <td>3521</td>\n",
       "      <td>[{'id': '102343', 'player_id': '3521', 'player...</td>\n",
       "      <td>[{'id': '135971', 'season': '18/19', 'player_i...</td>\n",
       "      <td>2005-01-01 00:00:00</td>\n",
       "      <td>西甲</td>\n",
       "      <td>36</td>\n",
       "      <td>武磊</td>\n",
       "      <td>Wu Lei</td>\n",
       "      <td>中国男足</td>\n",
       "      <td>243</td>\n",
       "      <td>中国</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>前锋</td>\n",
       "      <td>[{'position': '前腰', 'goals': '12'}, {'position...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>武磊</td>\n",
       "      <td>{'player_id': '3521', 'player': '武磊', 'season'...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>613</td>\n",
       "      <td>{'id': '613', 'name_cn': '西班牙人', 'name_en': 'E...</td>\n",
       "      <td>西班牙人</td>\n",
       "      <td>[{'id': '4180', 'player_id': '3521', 'from_tea...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>[{'id': '122014', 'vs_team_id': '2980', 'vs_te...</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3263</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>1988-02-12</td>\n",
       "      <td>[]</td>\n",
       "      <td>2021-12-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>[]</td>\n",
       "      <td>3522</td>\n",
       "      <td>[{'id': '1763', 'player_id': '3522', 'player':...</td>\n",
       "      <td>[{'id': '126537', 'season': '18/19', 'player_i...</td>\n",
       "      <td>2018-01-01 00:00:00</td>\n",
       "      <td>中超</td>\n",
       "      <td>353</td>\n",
       "      <td>杨旭</td>\n",
       "      <td>Yang Xu</td>\n",
       "      <td>中国男足</td>\n",
       "      <td>243</td>\n",
       "      <td>中国</td>\n",
       "      <td>9</td>\n",
       "      <td>87</td>\n",
       "      <td>前锋</td>\n",
       "      <td>[{'position': '前腰', 'goals': '4'}, {'position'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>杨旭</td>\n",
       "      <td>{'player_id': '3522', 'player': '杨旭', 'season'...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2985</td>\n",
       "      <td>{'id': '2985', 'name_cn': '天津天海', 'name_en': '...</td>\n",
       "      <td>天津天海</td>\n",
       "      <td>[{'id': '17447', 'player_id': '3522', 'from_te...</td>\n",
       "      <td>0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>[{'id': '18579', 'vs_team_id': '2983', 'vs_tea...</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3264</th>\n",
       "      <td>29</td>\n",
       "      <td>3</td>\n",
       "      <td>1989-08-26</td>\n",
       "      <td>[]</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>{'中国冠军杯冠军': {'honor': '中国冠军杯冠军', 'logo': 'http...</td>\n",
       "      <td>3523</td>\n",
       "      <td>[{'id': '1765', 'player_id': '3523', 'player':...</td>\n",
       "      <td>[{'id': '126536', 'season': '18/19', 'player_i...</td>\n",
       "      <td>2016-01-12 00:00:00</td>\n",
       "      <td>中超</td>\n",
       "      <td>353</td>\n",
       "      <td>孙可</td>\n",
       "      <td>Sun Ke</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>中国</td>\n",
       "      <td>38</td>\n",
       "      <td>633</td>\n",
       "      <td>前锋</td>\n",
       "      <td>[{'position': '前腰', 'goals': '1'}, {'position'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>孙可</td>\n",
       "      <td>{'player_id': '3523', 'player': '孙可', 'season'...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2985</td>\n",
       "      <td>{'id': '2985', 'name_cn': '天津天海', 'name_en': '...</td>\n",
       "      <td>天津天海</td>\n",
       "      <td>[{'id': '19851', 'player_id': '3523', 'from_te...</td>\n",
       "      <td>0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>[{'id': '18996', 'vs_team_id': '2980', 'vs_tea...</td>\n",
       "      <td>54</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3265</th>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>1989-02-09</td>\n",
       "      <td>[]</td>\n",
       "      <td>2021-12-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>[]</td>\n",
       "      <td>3524</td>\n",
       "      <td>[{'id': '1752', 'player_id': '3524', 'player':...</td>\n",
       "      <td>[{'id': '127764', 'season': '18/19', 'player_i...</td>\n",
       "      <td>2017-01-12 00:00:00</td>\n",
       "      <td>中超</td>\n",
       "      <td>353</td>\n",
       "      <td>张呈栋</td>\n",
       "      <td>Zhang Chengdong</td>\n",
       "      <td>中国男足</td>\n",
       "      <td>243</td>\n",
       "      <td>中国</td>\n",
       "      <td>28</td>\n",
       "      <td>810</td>\n",
       "      <td>前锋</td>\n",
       "      <td>[{'position': '后腰', 'goals': '2'}, {'position'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>张呈栋</td>\n",
       "      <td>{'player_id': '3524', 'player': '张呈栋', 'season...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2986</td>\n",
       "      <td>{'id': '2986', 'name_cn': '河北华夏幸福', 'name_en':...</td>\n",
       "      <td>河北华夏</td>\n",
       "      <td>[{'id': '4299', 'player_id': '3524', 'from_tea...</td>\n",
       "      <td>0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>[{'id': '126052', 'vs_team_id': '2987', 'vs_te...</td>\n",
       "      <td>73</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3266</th>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1986-02-14</td>\n",
       "      <td>[]</td>\n",
       "      <td>2020-12-31 00:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>{'最佳射手': {'honor': '最佳射手', 'logo': 'http://tu....</td>\n",
       "      <td>3525</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'id': '136340', 'season': '18/19', 'player_i...</td>\n",
       "      <td>2010-01-01 00:00:00</td>\n",
       "      <td>中超</td>\n",
       "      <td>353</td>\n",
       "      <td>郜林</td>\n",
       "      <td>Gao Lin</td>\n",
       "      <td>中国男足</td>\n",
       "      <td>243</td>\n",
       "      <td>中国</td>\n",
       "      <td>29</td>\n",
       "      <td>653</td>\n",
       "      <td>前锋</td>\n",
       "      <td>[{'position': '前腰', 'goals': '2'}, {'position'...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>{'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>郜林</td>\n",
       "      <td>{'player_id': '3525', 'player': '郜林', 'season'...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2982</td>\n",
       "      <td>{'id': '2982', 'name_cn': '广州恒大淘宝', 'name_en':...</td>\n",
       "      <td>广州恒大</td>\n",
       "      <td>[{'id': '10869', 'player_id': '3525', 'from_te...</td>\n",
       "      <td>0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>[{'id': '47959', 'vs_team_id': '2989', 'vs_tea...</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      age  assist    birthday charaters        contract_time  create_time  \\\n",
       "3262   27       0  1991-11-19        []  2020-12-31 00:00:00            0   \n",
       "3263   31       0  1988-02-12        []  2021-12-31 00:00:00            0   \n",
       "3264   29       3  1989-08-26        []  2020-12-31 00:00:00            0   \n",
       "3265   30       1  1989-02-09        []  2021-12-31 00:00:00            0   \n",
       "3266   33       1  1986-02-14        []  2020-12-31 00:00:00            0   \n",
       "\n",
       "      create_type  flag  games_played  goal habit_foot height  \\\n",
       "3262            0     1             0     0         右脚    174   \n",
       "3263            0     1             5     0         右脚    188   \n",
       "3264            0     1             8     1         右脚    180   \n",
       "3265            0     1             9     3         右脚    185   \n",
       "3266            0     1             9     3         右脚    185   \n",
       "\n",
       "                                                 honors    id  \\\n",
       "3262  {'最佳射手': {'honor': '最佳射手', 'logo': 'http://tu....  3521   \n",
       "3263                                                 []  3522   \n",
       "3264  {'中国冠军杯冠军': {'honor': '中国冠军杯冠军', 'logo': 'http...  3523   \n",
       "3265                                                 []  3524   \n",
       "3266  {'最佳射手': {'honor': '最佳射手', 'logo': 'http://tu....  3525   \n",
       "\n",
       "                                         injury_history  \\\n",
       "3262  [{'id': '102343', 'player_id': '3521', 'player...   \n",
       "3263  [{'id': '1763', 'player_id': '3522', 'player':...   \n",
       "3264  [{'id': '1765', 'player_id': '3523', 'player':...   \n",
       "3265  [{'id': '1752', 'player_id': '3524', 'player':...   \n",
       "3266                                                 []   \n",
       "\n",
       "                                         jersey_numbers            join_time  \\\n",
       "3262  [{'id': '135971', 'season': '18/19', 'player_i...  2005-01-01 00:00:00   \n",
       "3263  [{'id': '126537', 'season': '18/19', 'player_i...  2018-01-01 00:00:00   \n",
       "3264  [{'id': '126536', 'season': '18/19', 'player_i...  2016-01-12 00:00:00   \n",
       "3265  [{'id': '127764', 'season': '18/19', 'player_i...  2017-01-12 00:00:00   \n",
       "3266  [{'id': '136340', 'season': '18/19', 'player_i...  2010-01-01 00:00:00   \n",
       "\n",
       "     league  league_id name          name_en national_team  national_team_id  \\\n",
       "3262     西甲         36   武磊           Wu Lei          中国男足               243   \n",
       "3263     中超        353   杨旭          Yang Xu          中国男足               243   \n",
       "3264     中超        353   孙可           Sun Ke           NaN                 0   \n",
       "3265     中超        353  张呈栋  Zhang Chengdong          中国男足               243   \n",
       "3266     中超        353   郜林          Gao Lin          中国男足               243   \n",
       "\n",
       "     nationality  number  playing_time position  \\\n",
       "3262          中国      24             0       前锋   \n",
       "3263          中国       9            87       前锋   \n",
       "3264          中国      38           633       前锋   \n",
       "3265          中国      28           810       前锋   \n",
       "3266          中国      29           653       前锋   \n",
       "\n",
       "                                    position_performace read_card  red_card  \\\n",
       "3262  [{'position': '前腰', 'goals': '12'}, {'position...       NaN         0   \n",
       "3263  [{'position': '前腰', 'goals': '4'}, {'position'...       NaN         0   \n",
       "3264  [{'position': '前腰', 'goals': '1'}, {'position'...       NaN         0   \n",
       "3265  [{'position': '后腰', 'goals': '2'}, {'position'...       NaN         0   \n",
       "3266  [{'position': '前腰', 'goals': '2'}, {'position'...       NaN         0   \n",
       "\n",
       "      retired                                  season_performace short_en  \\\n",
       "3262        0  {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...      NaN   \n",
       "3263        0  {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...      NaN   \n",
       "3264        0  {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...      NaN   \n",
       "3265        0  {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...      NaN   \n",
       "3266        0  {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...      NaN   \n",
       "\n",
       "     short_name                               single_match_records  \\\n",
       "3262         武磊  {'player_id': '3521', 'player': '武磊', 'season'...   \n",
       "3263         杨旭  {'player_id': '3522', 'player': '杨旭', 'season'...   \n",
       "3264         孙可  {'player_id': '3523', 'player': '孙可', 'season'...   \n",
       "3265        张呈栋  {'player_id': '3524', 'player': '张呈栋', 'season...   \n",
       "3266         郜林  {'player_id': '3525', 'player': '郜林', 'season'...   \n",
       "\n",
       "      sports_type  sports_type_cat  team_id  \\\n",
       "3262            1               10      613   \n",
       "3263            1               10     2985   \n",
       "3264            1               10     2985   \n",
       "3265            1               10     2986   \n",
       "3266            1               10     2982   \n",
       "\n",
       "                                              team_info team_name  \\\n",
       "3262  {'id': '613', 'name_cn': '西班牙人', 'name_en': 'E...      西班牙人   \n",
       "3263  {'id': '2985', 'name_cn': '天津天海', 'name_en': '...      天津天海   \n",
       "3264  {'id': '2985', 'name_cn': '天津天海', 'name_en': '...      天津天海   \n",
       "3265  {'id': '2986', 'name_cn': '河北华夏幸福', 'name_en':...      河北华夏   \n",
       "3266  {'id': '2982', 'name_cn': '广州恒大淘宝', 'name_en':...      广州恒大   \n",
       "\n",
       "                                              transfers  update_time  value  \\\n",
       "3262  [{'id': '4180', 'player_id': '3521', 'from_tea...            0    0.0   \n",
       "3263  [{'id': '17447', 'player_id': '3522', 'from_te...            0   15.0   \n",
       "3264  [{'id': '19851', 'player_id': '3523', 'from_te...            0   35.0   \n",
       "3265  [{'id': '4299', 'player_id': '3524', 'from_tea...            0   50.0   \n",
       "3266  [{'id': '10869', 'player_id': '3525', 'from_te...            0   75.0   \n",
       "\n",
       "                                               vs_teams weight  yellow_card  \n",
       "3262  [{'id': '122014', 'vs_team_id': '2980', 'vs_te...     66            0  \n",
       "3263  [{'id': '18579', 'vs_team_id': '2983', 'vs_tea...     80            0  \n",
       "3264  [{'id': '18996', 'vs_team_id': '2980', 'vs_tea...     54            3  \n",
       "3265  [{'id': '126052', 'vs_team_id': '2987', 'vs_te...     73            1  \n",
       "3266  [{'id': '47959', 'vs_team_id': '2989', 'vs_tea...     75            2  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#筛选出中国球员\n",
    "data_china = data[data['nationality']=='中国']\n",
    "pd.set_option(\"display.max_columns\",500)\n",
    "data_china.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"eb5fc75901874f0298183f4b194d18bc\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_eb5fc75901874f0298183f4b194d18bc = echarts.init(\n",
       "            document.getElementById('eb5fc75901874f0298183f4b194d18bc'), 'white', {renderer: 'canvas'});\n",
       "        var option_eb5fc75901874f0298183f4b194d18bc = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u6570\\u91cf\",\n",
       "            \"data\": [\n",
       "                2,\n",
       "                3,\n",
       "                9,\n",
       "                14,\n",
       "                39,\n",
       "                43,\n",
       "                27,\n",
       "                49,\n",
       "                34,\n",
       "                70,\n",
       "                26,\n",
       "                33,\n",
       "                61,\n",
       "                41,\n",
       "                42,\n",
       "                25,\n",
       "                24,\n",
       "                12,\n",
       "                9,\n",
       "                9,\n",
       "                5,\n",
       "                3\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u6570\\u91cf\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"\\u6570\\u91cf\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                17,\n",
       "                18,\n",
       "                19,\n",
       "                20,\n",
       "                21,\n",
       "                22,\n",
       "                23,\n",
       "                24,\n",
       "                25,\n",
       "                26,\n",
       "                27,\n",
       "                28,\n",
       "                29,\n",
       "                30,\n",
       "                31,\n",
       "                32,\n",
       "                33,\n",
       "                34,\n",
       "                35,\n",
       "                36,\n",
       "                37,\n",
       "                38\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u6bcf\\u4e2a\\u5e74\\u9f84\\u7684\\u4e2d\\u56fd\\u7403\\u5458\\u6570\\u91cf\\u5206\\u5e03\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "        chart_eb5fc75901874f0298183f4b194d18bc.setOption(option_eb5fc75901874f0298183f4b194d18bc);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x109817e48>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看所有球员的年龄分布\n",
    "agelist = data_china.groupby(by='age').count()['id']\n",
    "\n",
    "bar = (\n",
    "    Bar()\n",
    "    .add_xaxis(agelist.index.tolist())\n",
    "    .add_yaxis(\"数量\", agelist.values.tolist())\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"每个年龄的中国球员数量分布\"))\n",
    ")\n",
    "bar.render_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#2，哪个国家的球员最多#"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nationality\n",
       "德国                   2168\n",
       "英格兰                  2160\n",
       "西班牙                  1699\n",
       "巴西                   1562\n",
       "日本                   1119\n",
       "阿根廷                   931\n",
       "意大利                   855\n",
       "法国                    722\n",
       "乌拉圭                   652\n",
       "瑞典                    640\n",
       "哥伦比亚                  628\n",
       "韩国                    601\n",
       "荷兰                    598\n",
       "中国                    580\n",
       "墨西哥                   551\n",
       "秘鲁                    522\n",
       "爱尔兰                   520\n",
       "挪威                    504\n",
       "波兰                    446\n",
       "智利                    434\n",
       "委内瑞拉                  433\n",
       "苏格兰                   433\n",
       "巴拉圭                   376\n",
       "北爱尔兰                  374\n",
       "俄罗斯                   365\n",
       "丹麦                    351\n",
       "捷克                    347\n",
       "罗马尼亚                  343\n",
       "葡萄牙                   334\n",
       "克罗地亚                  329\n",
       "                     ... \n",
       "德国,荷兰                   1\n",
       "德国,菲律宾                  1\n",
       "德国,贝宁                   1\n",
       "德国,阿富汗                  1\n",
       "意大利,Cote d'Ivoire       1\n",
       "意大利,加拿大                 1\n",
       "德国,乌兹别克斯坦               1\n",
       "德国,The Gambia           1\n",
       "尼日尔,马里                  1\n",
       "德国,Palästina            1\n",
       "巴巴多斯,加拿大                1\n",
       "巴巴多斯,美国                 1\n",
       "巴布亚新几内亚,德国              1\n",
       "巴布亚新几内亚,英格兰             1\n",
       "巴拉圭,厄瓜多尔                1\n",
       "巴拿马,乌拉圭                 1\n",
       "巴西,乌拉圭                  1\n",
       "巴西,土耳其                  1\n",
       "巴西,斯洛文尼亚                1\n",
       "巴西,日本                   1\n",
       "巴西,法国                   1\n",
       "巴西,波兰                   1\n",
       "巴西,立陶宛                  1\n",
       "巴西,美国                   1\n",
       "希腊,印度                   1\n",
       "希腊,塞尔维亚                 1\n",
       "希腊,英格兰                  1\n",
       "希腊,荷兰                   1\n",
       "德国,Congo                1\n",
       "黑山,瑞典                   1\n",
       "Name: id, Length: 1102, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_nation = data.groupby(by='nationality').count().sort_values(by='id',ascending=False)['id']\n",
    "data_nation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"ab7dbc3253b34791973bf1b095f7f218\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_ab7dbc3253b34791973bf1b095f7f218 = echarts.init(\n",
       "            document.getElementById('ab7dbc3253b34791973bf1b095f7f218'), 'white', {renderer: 'canvas'});\n",
       "        var option_ab7dbc3253b34791973bf1b095f7f218 = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"funnel\",\n",
       "            \"name\": \"\\u7403\\u5458\\u6570\\u91cf\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u5fb7\\u56fd\",\n",
       "                    \"value\": 2168\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u82f1\\u683c\\u5170\",\n",
       "                    \"value\": 2160\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u897f\\u73ed\\u7259\",\n",
       "                    \"value\": 1699\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5df4\\u897f\",\n",
       "                    \"value\": 1562\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u65e5\\u672c\",\n",
       "                    \"value\": 1119\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u963f\\u6839\\u5ef7\",\n",
       "                    \"value\": 931\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u610f\\u5927\\u5229\",\n",
       "                    \"value\": 855\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6cd5\\u56fd\",\n",
       "                    \"value\": 722\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e4c\\u62c9\\u572d\",\n",
       "                    \"value\": 652\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u745e\\u5178\",\n",
       "                    \"value\": 640\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u54e5\\u4f26\\u6bd4\\u4e9a\",\n",
       "                    \"value\": 628\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u97e9\\u56fd\",\n",
       "                    \"value\": 601\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8377\\u5170\",\n",
       "                    \"value\": 598\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e2d\\u56fd\",\n",
       "                    \"value\": 580\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u58a8\\u897f\\u54e5\",\n",
       "                    \"value\": 551\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u79d8\\u9c81\",\n",
       "                    \"value\": 522\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7231\\u5c14\\u5170\",\n",
       "                    \"value\": 520\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u632a\\u5a01\",\n",
       "                    \"value\": 504\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6ce2\\u5170\",\n",
       "                    \"value\": 446\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u667a\\u5229\",\n",
       "                    \"value\": 434\n",
       "                }\n",
       "            ],\n",
       "            \"sort\": \"descending\",\n",
       "            \"gap\": 0,\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u82f1\\u683c\\u5170\",\n",
       "                \"\\u897f\\u73ed\\u7259\",\n",
       "                \"\\u963f\\u6839\\u5ef7\",\n",
       "                \"\\u6cd5\\u56fd\",\n",
       "                \"\\u4e2d\\u56fd\",\n",
       "                \"\\u54e5\\u4f26\\u6bd4\\u4e9a\",\n",
       "                \"\\u58a8\\u897f\\u54e5\",\n",
       "                \"\\u610f\\u5927\\u5229\",\n",
       "                \"\\u8377\\u5170\",\n",
       "                \"\\u745e\\u5178\",\n",
       "                \"\\u5fb7\\u56fd\",\n",
       "                \"\\u7231\\u5c14\\u5170\",\n",
       "                \"\\u667a\\u5229\",\n",
       "                \"\\u65e5\\u672c\",\n",
       "                \"\\u79d8\\u9c81\",\n",
       "                \"\\u97e9\\u56fd\",\n",
       "                \"\\u6ce2\\u5170\",\n",
       "                \"\\u4e4c\\u62c9\\u572d\",\n",
       "                \"\\u632a\\u5a01\",\n",
       "                \"\\u5df4\\u897f\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"\\u5fb7\\u56fd\": true,\n",
       "                \"\\u82f1\\u683c\\u5170\": true,\n",
       "                \"\\u897f\\u73ed\\u7259\": true,\n",
       "                \"\\u5df4\\u897f\": true,\n",
       "                \"\\u65e5\\u672c\": true,\n",
       "                \"\\u963f\\u6839\\u5ef7\": true,\n",
       "                \"\\u610f\\u5927\\u5229\": true,\n",
       "                \"\\u6cd5\\u56fd\": true,\n",
       "                \"\\u4e4c\\u62c9\\u572d\": true,\n",
       "                \"\\u745e\\u5178\": true,\n",
       "                \"\\u54e5\\u4f26\\u6bd4\\u4e9a\": true,\n",
       "                \"\\u97e9\\u56fd\": true,\n",
       "                \"\\u8377\\u5170\": true,\n",
       "                \"\\u4e2d\\u56fd\": true,\n",
       "                \"\\u58a8\\u897f\\u54e5\": true,\n",
       "                \"\\u79d8\\u9c81\": true,\n",
       "                \"\\u7231\\u5c14\\u5170\": true,\n",
       "                \"\\u632a\\u5a01\": true,\n",
       "                \"\\u6ce2\\u5170\": true,\n",
       "                \"\\u667a\\u5229\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"title\": [\n",
       "        {}\n",
       "    ]\n",
       "};\n",
       "        chart_ab7dbc3253b34791973bf1b095f7f218.setOption(option_ab7dbc3253b34791973bf1b095f7f218);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x10a438400>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Funnel, Page\n",
    "\n",
    "c = (\n",
    "        Funnel()\n",
    "        .add(\"球员数量\", [list(z) for z in zip(data_nation[:20].index.tolist(), data_nation[:20].values.tolist())])\n",
    "        .set_global_opts(title_opts=opts.TitleOpts(title=\"\"))\n",
    "    )\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "3、球员的进球数据分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "age                                                                    27\n",
       "assist                                                                  0\n",
       "birthday                                                       1991-11-19\n",
       "charaters                                                              []\n",
       "contract_time                                         2020-12-31 00:00:00\n",
       "create_time                                                             0\n",
       "create_type                                                             0\n",
       "flag                                                                    1\n",
       "games_played                                                            0\n",
       "goal                                                                    0\n",
       "habit_foot                                                             右脚\n",
       "height                                                                174\n",
       "honors                  {'最佳射手': {'honor': '最佳射手', 'logo': 'http://tu....\n",
       "id                                                                   3521\n",
       "injury_history          [{'id': '102343', 'player_id': '3521', 'player...\n",
       "jersey_numbers          [{'id': '135971', 'season': '18/19', 'player_i...\n",
       "join_time                                             2005-01-01 00:00:00\n",
       "league                                                                 西甲\n",
       "league_id                                                              36\n",
       "name                                                                   武磊\n",
       "name_en                                                            Wu Lei\n",
       "national_team                                                        中国男足\n",
       "national_team_id                                                      243\n",
       "nationality                                                            中国\n",
       "number                                                                 24\n",
       "playing_time                                                            0\n",
       "position                                                               前锋\n",
       "position_performace     [{'position': '前腰', 'goals': '12'}, {'position...\n",
       "read_card                                                             NaN\n",
       "red_card                                                                0\n",
       "retired                                                                 0\n",
       "season_performace       {'league_type': ['赛事', '球队', '赛季', '出场次数', '进球...\n",
       "short_en                                                              NaN\n",
       "short_name                                                             武磊\n",
       "single_match_records    {'player_id': '3521', 'player': '武磊', 'season'...\n",
       "sports_type                                                             1\n",
       "sports_type_cat                                                        10\n",
       "team_id                                                               613\n",
       "team_info               {'id': '613', 'name_cn': '西班牙人', 'name_en': 'E...\n",
       "team_name                                                            西班牙人\n",
       "transfers               [{'id': '4180', 'player_id': '3521', 'from_tea...\n",
       "update_time                                                             0\n",
       "value                                                                   0\n",
       "vs_teams                [{'id': '122014', 'vs_team_id': '2980', 'vs_te...\n",
       "weight                                                                 66\n",
       "yellow_card                                                             0\n",
       "Name: 3262, dtype: object"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[3262]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'出场次数': 233,\n",
       " '进球': 123,\n",
       " '助攻': 67,\n",
       " '红牌': 0,\n",
       " '黄牌': 21,\n",
       " '替补上场': 8,\n",
       " '替补下场': 65,\n",
       " '出场总时间': 20181,\n",
       " '黄变红': 1,\n",
       " '场均积分': '2.04',\n",
       " '乌龙球': 0,\n",
       " '进点球': 3,\n",
       " '进球间隔时间': '164.07'}"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#获取武磊的历史个人数据汇总信息\n",
    "eval(data.loc[3262]['season_performace'])['total']['总计']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "#把所有球员的数据汇总信息都提取到data表中\n",
    "#第一步，历史总出场数据\n",
    "def get_total_play(sp):\n",
    "    if sp == '[]':\n",
    "        return 0\n",
    "        print(0)\n",
    "    else:\n",
    "        return eval(sp)['total']['总计']['出场次数']\n",
    "        print(eval(sp)['total']['总计']['出场次数'])\n",
    "        \n",
    "data['total_play'] = data['season_performace'].apply(get_total_play)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [],
   "source": [
    "#第2步，历史总进球数据\n",
    "def get_total_goal(sp):\n",
    "    if sp == '[]':\n",
    "        return 0\n",
    "    else:\n",
    "        return eval(sp)['total']['总计']['进球']\n",
    "        \n",
    "data['total_goal'] = data['season_performace'].apply(get_total_goal)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [],
   "source": [
    "#第3步，历史总助攻数据\n",
    "def get_total_assist(sp):\n",
    "    if sp == '[]':\n",
    "        return 0\n",
    "    else:\n",
    "        return eval(sp)['total']['总计']['助攻']\n",
    "        \n",
    "data['total_assist'] = data['season_performace'].apply(get_total_assist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>games_played</th>\n",
       "      <th>habit_foot</th>\n",
       "      <th>height</th>\n",
       "      <th>name</th>\n",
       "      <th>name_en</th>\n",
       "      <th>nationality</th>\n",
       "      <th>position</th>\n",
       "      <th>team_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>total_play</th>\n",
       "      <th>total_goal</th>\n",
       "      <th>total_assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23</td>\n",
       "      <td>30</td>\n",
       "      <td>左脚</td>\n",
       "      <td>184</td>\n",
       "      <td>萨内</td>\n",
       "      <td>Leroy Sané</td>\n",
       "      <td>德国,法国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>曼城</td>\n",
       "      <td>0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>271</td>\n",
       "      <td>72</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>29</td>\n",
       "      <td>28</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>托马斯-穆勒</td>\n",
       "      <td>Thomas Müller</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>5500.0</td>\n",
       "      <td>569</td>\n",
       "      <td>227</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>许尔勒</td>\n",
       "      <td>Andre Schurrle</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>富勒姆</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>402</td>\n",
       "      <td>108</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33</td>\n",
       "      <td>16</td>\n",
       "      <td>右脚</td>\n",
       "      <td>189</td>\n",
       "      <td>戈麦斯</td>\n",
       "      <td>Mario Gomez</td>\n",
       "      <td>德国,西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>斯图加特</td>\n",
       "      <td>0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>570</td>\n",
       "      <td>310</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>33</td>\n",
       "      <td>11</td>\n",
       "      <td>左脚</td>\n",
       "      <td>182</td>\n",
       "      <td>波多尔斯基</td>\n",
       "      <td>Lukas Podolski</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>神户胜利船</td>\n",
       "      <td>0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>522</td>\n",
       "      <td>199</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>24</td>\n",
       "      <td>28</td>\n",
       "      <td>右脚</td>\n",
       "      <td>176</td>\n",
       "      <td>基米希</td>\n",
       "      <td>Joshua Kimmich</td>\n",
       "      <td>德国</td>\n",
       "      <td>后卫</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>5500.0</td>\n",
       "      <td>281</td>\n",
       "      <td>29</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>魏格尔</td>\n",
       "      <td>Julian Weigl</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>多特蒙德</td>\n",
       "      <td>0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>266</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>25</td>\n",
       "      <td>29</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>德拉克斯勒</td>\n",
       "      <td>Julian Draxler</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>巴黎圣日耳曼</td>\n",
       "      <td>0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>386</td>\n",
       "      <td>83</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>29</td>\n",
       "      <td>25</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>克罗斯</td>\n",
       "      <td>Toni Kroos</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>皇家马德里</td>\n",
       "      <td>0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>519</td>\n",
       "      <td>58</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>30</td>\n",
       "      <td>26</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>厄齐尔</td>\n",
       "      <td>Mesut zil</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>阿森纳</td>\n",
       "      <td>0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>573</td>\n",
       "      <td>104</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>32</td>\n",
       "      <td>26</td>\n",
       "      <td>右脚</td>\n",
       "      <td>189</td>\n",
       "      <td>赫迪拉</td>\n",
       "      <td>Sami Khedira</td>\n",
       "      <td>德国,突尼斯</td>\n",
       "      <td>中场</td>\n",
       "      <td>尤文图斯</td>\n",
       "      <td>0</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>455</td>\n",
       "      <td>50</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>26</td>\n",
       "      <td>23</td>\n",
       "      <td>右脚</td>\n",
       "      <td>176</td>\n",
       "      <td>格策</td>\n",
       "      <td>Mario G?tze</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>多特蒙德</td>\n",
       "      <td>0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>357</td>\n",
       "      <td>101</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>埃姆雷-詹</td>\n",
       "      <td>Emre Can</td>\n",
       "      <td>德国</td>\n",
       "      <td>中场</td>\n",
       "      <td>尤文图斯</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>321</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>赫韦德斯</td>\n",
       "      <td>Benedikt Howedes</td>\n",
       "      <td>德国</td>\n",
       "      <td>后卫</td>\n",
       "      <td>莫斯科火车头</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>429</td>\n",
       "      <td>40</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>右脚</td>\n",
       "      <td>191</td>\n",
       "      <td>吕迪格</td>\n",
       "      <td>Antonio Rüdiger</td>\n",
       "      <td>德国,塞拉利昂</td>\n",
       "      <td>后卫</td>\n",
       "      <td>切尔西</td>\n",
       "      <td>0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>310</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>右脚</td>\n",
       "      <td>192</td>\n",
       "      <td>博阿滕</td>\n",
       "      <td>Jerome Boateng</td>\n",
       "      <td>德国</td>\n",
       "      <td>后卫</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>475</td>\n",
       "      <td>14</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>30</td>\n",
       "      <td>25</td>\n",
       "      <td>右脚</td>\n",
       "      <td>191</td>\n",
       "      <td>胡梅尔斯</td>\n",
       "      <td>Mats Hummels</td>\n",
       "      <td>德国</td>\n",
       "      <td>后卫</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>499</td>\n",
       "      <td>46</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>27</td>\n",
       "      <td>25</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>穆斯塔菲</td>\n",
       "      <td>Shkodran Mustafi</td>\n",
       "      <td>德国,阿尔巴尼亚</td>\n",
       "      <td>后卫</td>\n",
       "      <td>阿森纳</td>\n",
       "      <td>0</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>321</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>28</td>\n",
       "      <td>19</td>\n",
       "      <td>左脚</td>\n",
       "      <td>185</td>\n",
       "      <td>赫克托</td>\n",
       "      <td>Jonas Hector</td>\n",
       "      <td>德国</td>\n",
       "      <td>后卫</td>\n",
       "      <td>科隆</td>\n",
       "      <td>0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>315</td>\n",
       "      <td>25</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>190</td>\n",
       "      <td>莱诺</td>\n",
       "      <td>Bernd Leno</td>\n",
       "      <td>德国</td>\n",
       "      <td>守门员</td>\n",
       "      <td>阿森纳</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>433</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>33</td>\n",
       "      <td>3</td>\n",
       "      <td>右脚</td>\n",
       "      <td>193</td>\n",
       "      <td>诺伊尔</td>\n",
       "      <td>Manuel Neuer</td>\n",
       "      <td>德国</td>\n",
       "      <td>守门员</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>3500.0</td>\n",
       "      <td>594</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>27</td>\n",
       "      <td>35</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>特尔施特根</td>\n",
       "      <td>Marc-André ter Stege</td>\n",
       "      <td>德国</td>\n",
       "      <td>守门员</td>\n",
       "      <td>巴塞罗那</td>\n",
       "      <td>0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>387</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>多米尼克-索兰克</td>\n",
       "      <td>Dominic Solanke</td>\n",
       "      <td>英格兰,尼日利亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>伯恩茅斯</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>115</td>\n",
       "      <td>46</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>27</td>\n",
       "      <td>36</td>\n",
       "      <td>右脚</td>\n",
       "      <td>181</td>\n",
       "      <td>罗伯托-菲尔米诺</td>\n",
       "      <td>Roberto Firmino Barb</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>381</td>\n",
       "      <td>123</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>178</td>\n",
       "      <td>丹尼-英斯</td>\n",
       "      <td>Danny Ings</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>南安普顿</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>220</td>\n",
       "      <td>68</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>萨迪奥-马内</td>\n",
       "      <td>Sadio Mané</td>\n",
       "      <td>塞内加尔</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>300</td>\n",
       "      <td>128</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>丹尼尔-斯图里奇</td>\n",
       "      <td>Daniel Sturridge</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>310</td>\n",
       "      <td>111</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>伍德伯恩-本亚名</td>\n",
       "      <td>Woodburn Benjamin</td>\n",
       "      <td>威尔士,英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>26</td>\n",
       "      <td>35</td>\n",
       "      <td>左脚</td>\n",
       "      <td>175</td>\n",
       "      <td>穆罕默德-萨拉赫</td>\n",
       "      <td>Mohamed Salah</td>\n",
       "      <td>埃及</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>353</td>\n",
       "      <td>147</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>11</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>172</td>\n",
       "      <td>亚当-拉拉纳</td>\n",
       "      <td>Adam Lallana</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>中场</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>420</td>\n",
       "      <td>80</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33072</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Amos Korankye</td>\n",
       "      <td>Amos Korankye</td>\n",
       "      <td>加纳</td>\n",
       "      <td>后卫</td>\n",
       "      <td>Medeama SC</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33073</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>184</td>\n",
       "      <td>Enrique Royo</td>\n",
       "      <td>Enrique Royo</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>守门员</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>226</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33074</th>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>Pawel Florek</td>\n",
       "      <td>Pawel Florek</td>\n",
       "      <td>波兰</td>\n",
       "      <td>守门员</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33075</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>Mario Gómez</td>\n",
       "      <td>Mario Gómez</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>124</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33076</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>185</td>\n",
       "      <td>César Morgado</td>\n",
       "      <td>César Morgado</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33077</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>-</td>\n",
       "      <td>Nil Coch</td>\n",
       "      <td>Nil Coch</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pobla de Mafumet CF</td>\n",
       "      <td>0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33078</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>168</td>\n",
       "      <td>Eneko Zabaleta</td>\n",
       "      <td>Eneko Zabaleta</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>123</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33079</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>181</td>\n",
       "      <td>Cristian Pérez</td>\n",
       "      <td>Cristian Pérez</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>143</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33080</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>182</td>\n",
       "      <td>Juanjo García</td>\n",
       "      <td>Juanjo García</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33081</th>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Toni Abad</td>\n",
       "      <td>Toni Abad</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>后卫</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33082</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>Julio Cidoncha</td>\n",
       "      <td>Julio Cidoncha</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>中场</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33083</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>176</td>\n",
       "      <td>Damián Petcoff</td>\n",
       "      <td>Damián Petcoff</td>\n",
       "      <td>阿根廷,西班牙</td>\n",
       "      <td>中场</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33084</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>178</td>\n",
       "      <td>Mohamed Kamal</td>\n",
       "      <td>Mohamed Kamal</td>\n",
       "      <td>西班牙,摩洛哥</td>\n",
       "      <td>中场</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33085</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>181</td>\n",
       "      <td>Ezequiel Lamarca</td>\n",
       "      <td>Ezequiel Lamarca</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD El Ejido 2012</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33086</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Javier Alonso</td>\n",
       "      <td>NaN</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>中场</td>\n",
       "      <td>CD Izarra</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33087</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>José ?ngel</td>\n",
       "      <td>José ?ngel</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>中场</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>118</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33088</th>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>173</td>\n",
       "      <td>David Aparicio</td>\n",
       "      <td>David Aparicio</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SD Balmaseda</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33089</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>171</td>\n",
       "      <td>José Higón</td>\n",
       "      <td>José Higón</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33090</th>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>174</td>\n",
       "      <td>David Martín</td>\n",
       "      <td>NaN</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>171</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33091</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>Guzmán Casaseca</td>\n",
       "      <td>NaN</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>267</td>\n",
       "      <td>35</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33092</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>Francis Ferrón</td>\n",
       "      <td>Francis Ferrón</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33093</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>Eder Díez</td>\n",
       "      <td>NaN</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>CD Badajoz</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>118</td>\n",
       "      <td>23</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33094</th>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Renato Da Silva</td>\n",
       "      <td>NaN</td>\n",
       "      <td>巴西</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UCAM Murcia B</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33095</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>179</td>\n",
       "      <td>Mohd Fazli</td>\n",
       "      <td>Mohd Fazli</td>\n",
       "      <td>马来西亚</td>\n",
       "      <td>守门员</td>\n",
       "      <td>Melaka United SA</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33096</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Syawal Norsam</td>\n",
       "      <td>Syawal Norsam</td>\n",
       "      <td>马来西亚</td>\n",
       "      <td>后卫</td>\n",
       "      <td>Melaka United SA</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33097</th>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>Mohd Azmi</td>\n",
       "      <td>Mohd Azmi</td>\n",
       "      <td>马来西亚</td>\n",
       "      <td>后卫</td>\n",
       "      <td>Melaka United SA</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33098</th>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Eric Kwakwa</td>\n",
       "      <td>Eric Kwakwa</td>\n",
       "      <td>加纳</td>\n",
       "      <td>中场</td>\n",
       "      <td>Medeama SC</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33099</th>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>-</td>\n",
       "      <td>-</td>\n",
       "      <td>Kwame Boateng</td>\n",
       "      <td>Kwame Boateng</td>\n",
       "      <td>加纳</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Medeama SC</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>31</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33100</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>191</td>\n",
       "      <td>Khair Jones</td>\n",
       "      <td>Khair Jones</td>\n",
       "      <td>马来西亚,新西兰</td>\n",
       "      <td>后卫</td>\n",
       "      <td>Melaka United SA</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33101</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>-</td>\n",
       "      <td>Puaneswaran</td>\n",
       "      <td>Puaneswaran</td>\n",
       "      <td>马来西亚</td>\n",
       "      <td>后卫</td>\n",
       "      <td>Melaka United SA</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>33102 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       age  games_played habit_foot height              name  \\\n",
       "0       23            30         左脚    184                萨内   \n",
       "1       29            28         右脚    186            托马斯-穆勒   \n",
       "2       28             0         右脚    184               许尔勒   \n",
       "3       33            16         右脚    189               戈麦斯   \n",
       "4       33            11         左脚    182             波多尔斯基   \n",
       "5       24            28         右脚    176               基米希   \n",
       "6       23            24         右脚    186               魏格尔   \n",
       "7       25            29         右脚    187             德拉克斯勒   \n",
       "8       29            25        左右脚    183               克罗斯   \n",
       "9       30            26         左脚    180               厄齐尔   \n",
       "10      32            26         右脚    189               赫迪拉   \n",
       "11      26            23         右脚    176                格策   \n",
       "12      25             0         右脚    186             埃姆雷-詹   \n",
       "13      31             0         右脚    187              赫韦德斯   \n",
       "14      26            26         右脚    191               吕迪格   \n",
       "15      30            19         右脚    192               博阿滕   \n",
       "16      30            25         右脚    191              胡梅尔斯   \n",
       "17      27            25         右脚    184              穆斯塔菲   \n",
       "18      28            19         左脚    185               赫克托   \n",
       "19      27             0         右脚    190                莱诺   \n",
       "20      33             3         右脚    193               诺伊尔   \n",
       "21      27            35         右脚    187             特尔施特根   \n",
       "22      21             0         右脚    186          多米尼克-索兰克   \n",
       "23      27            36         右脚    181          罗伯托-菲尔米诺   \n",
       "24      26             0         右脚    178             丹尼-英斯   \n",
       "25      27            28         右脚    174            萨迪奥-马内   \n",
       "26      29             0         左脚    180          丹尼尔-斯图里奇   \n",
       "27      19             0         右脚    174          伍德伯恩-本亚名   \n",
       "28      26            35         左脚    175          穆罕默德-萨拉赫   \n",
       "29      30            11        左右脚    172            亚当-拉拉纳   \n",
       "...    ...           ...        ...    ...               ...   \n",
       "33072   28             0          -      -     Amos Korankye   \n",
       "33073   27             0          -    184      Enrique Royo   \n",
       "33074   22             0         右脚    188      Pawel Florek   \n",
       "33075   26             0         右脚    183       Mario Gómez   \n",
       "33076   26             0         左脚    185     César Morgado   \n",
       "33077   21             0         左脚      -          Nil Coch   \n",
       "33078   27             0         左脚    168    Eneko Zabaleta   \n",
       "33079   28             0        左右脚    181    Cristian Pérez   \n",
       "33080   31             0          -    182     Juanjo García   \n",
       "33081   23             0          -      -         Toni Abad   \n",
       "33082   30             0         右脚    185    Julio Cidoncha   \n",
       "33083   28             0         右脚    176    Damián Petcoff   \n",
       "33084   27             0          -    178     Mohamed Kamal   \n",
       "33085   27             0          -    181  Ezequiel Lamarca   \n",
       "33086   21             0          -      -     Javier Alonso   \n",
       "33087   34             0         右脚    180        José ?ngel   \n",
       "33088   22             0         左脚    173    David Aparicio   \n",
       "33089   27             0         右脚    171        José Higón   \n",
       "33090   26             0          -    174      David Martín   \n",
       "33091   34             0         右脚    180   Guzmán Casaseca   \n",
       "33092   29             0         右脚    184    Francis Ferrón   \n",
       "33093   31             0         右脚    187         Eder Díez   \n",
       "33094   21             0          -      -   Renato Da Silva   \n",
       "33095   31             0          -    179        Mohd Fazli   \n",
       "33096   29             0          -      -     Syawal Norsam   \n",
       "33097   32             0         左脚    180         Mohd Azmi   \n",
       "33098   24             0          -      -       Eric Kwakwa   \n",
       "33099   28             0          -      -     Kwame Boateng   \n",
       "33100   29             0        左右脚    191       Khair Jones   \n",
       "33101   35             0         右脚      -       Puaneswaran   \n",
       "\n",
       "                    name_en nationality position            team_name  \\\n",
       "0                Leroy Sané       德国,法国       前锋                   曼城   \n",
       "1             Thomas Müller          德国       前锋                拜仁慕尼黑   \n",
       "2            Andre Schurrle          德国       前锋                  富勒姆   \n",
       "3               Mario Gomez      德国,西班牙       前锋                 斯图加特   \n",
       "4            Lukas Podolski          德国       前锋                神户胜利船   \n",
       "5            Joshua Kimmich          德国       后卫                拜仁慕尼黑   \n",
       "6              Julian Weigl          德国       中场                 多特蒙德   \n",
       "7            Julian Draxler          德国       中场               巴黎圣日耳曼   \n",
       "8                Toni Kroos          德国       中场                皇家马德里   \n",
       "9                 Mesut zil          德国       中场                  阿森纳   \n",
       "10             Sami Khedira      德国,突尼斯       中场                 尤文图斯   \n",
       "11              Mario G?tze          德国       中场                 多特蒙德   \n",
       "12                 Emre Can          德国       中场                 尤文图斯   \n",
       "13         Benedikt Howedes          德国       后卫               莫斯科火车头   \n",
       "14          Antonio Rüdiger     德国,塞拉利昂       后卫                  切尔西   \n",
       "15           Jerome Boateng          德国       后卫                拜仁慕尼黑   \n",
       "16             Mats Hummels          德国       后卫                拜仁慕尼黑   \n",
       "17         Shkodran Mustafi    德国,阿尔巴尼亚       后卫                  阿森纳   \n",
       "18             Jonas Hector          德国       后卫                   科隆   \n",
       "19               Bernd Leno          德国      守门员                  阿森纳   \n",
       "20             Manuel Neuer          德国      守门员                拜仁慕尼黑   \n",
       "21     Marc-André ter Stege          德国      守门员                 巴塞罗那   \n",
       "22          Dominic Solanke    英格兰,尼日利亚       前锋                 伯恩茅斯   \n",
       "23     Roberto Firmino Barb          巴西       前锋                  利物浦   \n",
       "24               Danny Ings         英格兰       前锋                 南安普顿   \n",
       "25               Sadio Mané        塞内加尔       前锋                  利物浦   \n",
       "26         Daniel Sturridge         英格兰       前锋                  利物浦   \n",
       "27        Woodburn Benjamin     威尔士,英格兰       前锋                  利物浦   \n",
       "28            Mohamed Salah          埃及       前锋                  利物浦   \n",
       "29             Adam Lallana         英格兰       中场                  利物浦   \n",
       "...                     ...         ...      ...                  ...   \n",
       "33072         Amos Korankye          加纳       后卫           Medeama SC   \n",
       "33073          Enrique Royo         西班牙      守门员           CD Badajoz   \n",
       "33074          Pawel Florek          波兰      守门员           CD Badajoz   \n",
       "33075           Mario Gómez         西班牙       后卫           CD Badajoz   \n",
       "33076         César Morgado         西班牙       后卫           CD Badajoz   \n",
       "33077              Nil Coch         西班牙      NaN  Pobla de Mafumet CF   \n",
       "33078        Eneko Zabaleta         西班牙       后卫           CD Badajoz   \n",
       "33079        Cristian Pérez         西班牙       后卫           CD Badajoz   \n",
       "33080         Juanjo García         西班牙       后卫           CD Badajoz   \n",
       "33081             Toni Abad         西班牙       后卫           CD Badajoz   \n",
       "33082        Julio Cidoncha         西班牙       中场           CD Badajoz   \n",
       "33083        Damián Petcoff     阿根廷,西班牙       中场           CD Badajoz   \n",
       "33084         Mohamed Kamal     西班牙,摩洛哥       中场           CD Badajoz   \n",
       "33085      Ezequiel Lamarca         西班牙       前锋     CD El Ejido 2012   \n",
       "33086                   NaN         西班牙       中场            CD Izarra   \n",
       "33087            José ?ngel         西班牙       中场           CD Badajoz   \n",
       "33088        David Aparicio         西班牙      NaN         SD Balmaseda   \n",
       "33089            José Higón         西班牙       前锋           CD Badajoz   \n",
       "33090                   NaN         西班牙       前锋           CD Badajoz   \n",
       "33091                   NaN         西班牙       前锋           CD Badajoz   \n",
       "33092        Francis Ferrón         西班牙       前锋           CD Badajoz   \n",
       "33093                   NaN         西班牙       前锋           CD Badajoz   \n",
       "33094                   NaN          巴西      NaN        UCAM Murcia B   \n",
       "33095            Mohd Fazli        马来西亚      守门员     Melaka United SA   \n",
       "33096         Syawal Norsam        马来西亚       后卫     Melaka United SA   \n",
       "33097             Mohd Azmi        马来西亚       后卫     Melaka United SA   \n",
       "33098           Eric Kwakwa          加纳       中场           Medeama SC   \n",
       "33099         Kwame Boateng          加纳       前锋           Medeama SC   \n",
       "33100           Khair Jones    马来西亚,新西兰       后卫     Melaka United SA   \n",
       "33101           Puaneswaran        马来西亚       后卫     Melaka United SA   \n",
       "\n",
       "       update_time   value  total_play  total_goal  total_assist  \n",
       "0                0  7500.0         271          72            73  \n",
       "1                0  5500.0         569         227           166  \n",
       "2                0     0.0         402         108            47  \n",
       "3                0   600.0         570         310            70  \n",
       "4                0   800.0         522         199           109  \n",
       "5                0  5500.0         281          29            53  \n",
       "6                0  3000.0         266           8             5  \n",
       "7                0  4000.0         386          83            72  \n",
       "8                0  8000.0         519          58           126  \n",
       "9                0  5000.0         573         104           213  \n",
       "10               0  2800.0         455          50            47  \n",
       "11               0  2000.0         357         101            97  \n",
       "12               0     0.0         321          30            20  \n",
       "13               0     0.0         429          40            13  \n",
       "14               0  4000.0         310          16             8  \n",
       "15               0  4500.0         475          14            31  \n",
       "16               0  6000.0         499          46            25  \n",
       "17               0  2800.0         321          20            10  \n",
       "18               0  1100.0         315          25            43  \n",
       "19               0     0.0         433           0             0  \n",
       "20               0  3500.0         594           0             0  \n",
       "21               0  6000.0         387           0             0  \n",
       "22               0     0.0         115          46             9  \n",
       "23               0  5000.0         381         123            83  \n",
       "24               0     0.0         220          68            21  \n",
       "25               0  6000.0         300         128            69  \n",
       "26               0     0.0         310         111            42  \n",
       "27               0     0.0          59          15            13  \n",
       "28               0  8000.0         353         147            83  \n",
       "29               0  2500.0         420          80            68  \n",
       "...            ...     ...         ...         ...           ...  \n",
       "33072            0     0.0          10           2             0  \n",
       "33073            0     0.0         226           0             0  \n",
       "33074            0     0.0          90           0             0  \n",
       "33075            0     0.0         124           3             1  \n",
       "33076            0     0.0         134          11             0  \n",
       "33077            0     5.0           9           0             0  \n",
       "33078            0     0.0         123           7             0  \n",
       "33079            0     0.0         143           0             0  \n",
       "33080            0     0.0         170           1             0  \n",
       "33081            0     0.0          18           0             0  \n",
       "33082            0     0.0          95           5             0  \n",
       "33083            0     0.0         155           7             0  \n",
       "33084            0     0.0         115           3             1  \n",
       "33085            0     0.0          65          13             0  \n",
       "33086            0     0.0          39           1             0  \n",
       "33087            0     0.0         118           6             2  \n",
       "33088            0     0.0          33           1             0  \n",
       "33089            0     0.0         150          18             1  \n",
       "33090            0     0.0         171          11             0  \n",
       "33091            0     0.0         267          35            17  \n",
       "33092            0     0.0         207          56             1  \n",
       "33093            0     0.0         118          23             3  \n",
       "33094            0     0.0           3           0             0  \n",
       "33095            0     0.0          16           0             0  \n",
       "33096            0     0.0           5           0             0  \n",
       "33097            0     0.0          26           0             1  \n",
       "33098            0     0.0          31           1             0  \n",
       "33099            0     0.0          31           9             2  \n",
       "33100            0     0.0          46           2             2  \n",
       "33101            0     0.0          30           0             3  \n",
       "\n",
       "[33102 rows x 14 columns]"
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#先进行进球数据的分析\n",
    "\n",
    "#data.total_goal.value_counts().sort_index(ascending=False)\n",
    "\n",
    "col=['age', 'games_played', \n",
    "       'habit_foot', 'height',\n",
    "       'name', 'name_en',\n",
    "       'nationality',\n",
    "        'position','team_name', 'update_time', 'value',\n",
    "       'total_play', 'total_goal',\n",
    "       'total_assist']\n",
    "data[col]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>total_goal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2208</th>\n",
       "      <td>C罗</td>\n",
       "      <td>600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>梅西</td>\n",
       "      <td>598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>伊布</td>\n",
       "      <td>428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2895</th>\n",
       "      <td>莱万多夫斯基</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3012</th>\n",
       "      <td>苏亚雷斯</td>\n",
       "      <td>384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>塞尔吉奥-阿圭罗</td>\n",
       "      <td>348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11651</th>\n",
       "      <td>亨特拉尔</td>\n",
       "      <td>344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3009</th>\n",
       "      <td>卡瓦尼</td>\n",
       "      <td>333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19653</th>\n",
       "      <td>比利亚</td>\n",
       "      <td>315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>戈麦斯</td>\n",
       "      <td>310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32587</th>\n",
       "      <td>鲁尼</td>\n",
       "      <td>295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>伊瓜因</td>\n",
       "      <td>293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9887</th>\n",
       "      <td>M.罗巴克</td>\n",
       "      <td>289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2207</th>\n",
       "      <td>本泽马</td>\n",
       "      <td>288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3325</th>\n",
       "      <td>胡尔克</td>\n",
       "      <td>281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7245</th>\n",
       "      <td>克拉迪奥-皮萨罗</td>\n",
       "      <td>277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6840</th>\n",
       "      <td>哲科</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15158</th>\n",
       "      <td>范佩西</td>\n",
       "      <td>274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8878</th>\n",
       "      <td>法尔考</td>\n",
       "      <td>268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2305</th>\n",
       "      <td>杰梅因-迪福</td>\n",
       "      <td>249</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           name  total_goal\n",
       "2208         C罗         600\n",
       "53           梅西         598\n",
       "1679         伊布         428\n",
       "2895     莱万多夫斯基         385\n",
       "3012       苏亚雷斯         384\n",
       "54     塞尔吉奥-阿圭罗         348\n",
       "11651      亨特拉尔         344\n",
       "3009        卡瓦尼         333\n",
       "19653       比利亚         315\n",
       "3           戈麦斯         310\n",
       "32587        鲁尼         295\n",
       "55          伊瓜因         293\n",
       "9887      M.罗巴克         289\n",
       "2207        本泽马         288\n",
       "3325        胡尔克         281\n",
       "7245   克拉迪奥-皮萨罗         277\n",
       "6840         哲科         275\n",
       "15158       范佩西         274\n",
       "8878        法尔考         268\n",
       "2305     杰梅因-迪福         249"
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#goal_analyse = data[col].sort_values(by='total_goal',ascending=False)[:20]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"f3bc90b6362d486da63953ca83aedfb8\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_f3bc90b6362d486da63953ca83aedfb8 = echarts.init(\n",
       "            document.getElementById('f3bc90b6362d486da63953ca83aedfb8'), 'white', {renderer: 'canvas'});\n",
       "        var option_f3bc90b6362d486da63953ca83aedfb8 = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u8fdb\\u7403\\u6570\",\n",
       "            \"data\": [\n",
       "                600,\n",
       "                598,\n",
       "                428,\n",
       "                385,\n",
       "                384,\n",
       "                348,\n",
       "                344,\n",
       "                333,\n",
       "                315,\n",
       "                310,\n",
       "                295,\n",
       "                293,\n",
       "                289,\n",
       "                288,\n",
       "                281,\n",
       "                277,\n",
       "                275,\n",
       "                274,\n",
       "                268,\n",
       "                249\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u8fdb\\u7403\\u6570\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"\\u8fdb\\u7403\\u6570\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"C\\u7f57\",\n",
       "                \"\\u6885\\u897f\",\n",
       "                \"\\u4f0a\\u5e03\",\n",
       "                \"\\u83b1\\u4e07\\u591a\\u592b\\u65af\\u57fa\",\n",
       "                \"\\u82cf\\u4e9a\\u96f7\\u65af\",\n",
       "                \"\\u585e\\u5c14\\u5409\\u5965-\\u963f\\u572d\\u7f57\",\n",
       "                \"\\u4ea8\\u7279\\u62c9\\u5c14\",\n",
       "                \"\\u5361\\u74e6\\u5c3c\",\n",
       "                \"\\u6bd4\\u5229\\u4e9a\",\n",
       "                \"\\u6208\\u9ea6\\u65af\",\n",
       "                \"\\u9c81\\u5c3c\",\n",
       "                \"\\u4f0a\\u74dc\\u56e0\",\n",
       "                \"M.\\u7f57\\u5df4\\u514b\",\n",
       "                \"\\u672c\\u6cfd\\u9a6c\",\n",
       "                \"\\u80e1\\u5c14\\u514b\",\n",
       "                \"\\u514b\\u62c9\\u8fea\\u5965-\\u76ae\\u8428\\u7f57\",\n",
       "                \"\\u54f2\\u79d1\",\n",
       "                \"\\u8303\\u4f69\\u897f\",\n",
       "                \"\\u6cd5\\u5c14\\u8003\",\n",
       "                \"\\u6770\\u6885\\u56e0-\\u8fea\\u798f\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u8fdb\\u7403\\u6570\\u524d20\\u7684\\u7403\\u5458\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "        chart_f3bc90b6362d486da63953ca83aedfb8.setOption(option_f3bc90b6362d486da63953ca83aedfb8);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x10c19abe0>"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#agelist = data_china.groupby(by='age').count()['id']\n",
    "goal_analyse = data[col].sort_values(by='total_goal',ascending=False)[:20]\n",
    "bar = (\n",
    "    Bar()\n",
    "    .add_xaxis(goal_analyse.name.tolist())\n",
    "    .add_yaxis(\"进球数\", goal_analyse.total_goal.tolist())\n",
    "    .reversal_axis()\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"进球数前20的球员\"))\n",
    ")\n",
    "bar.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>games_played</th>\n",
       "      <th>habit_foot</th>\n",
       "      <th>height</th>\n",
       "      <th>name</th>\n",
       "      <th>name_en</th>\n",
       "      <th>nationality</th>\n",
       "      <th>position</th>\n",
       "      <th>team_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>total_play</th>\n",
       "      <th>total_goal</th>\n",
       "      <th>total_assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3262</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>武磊</td>\n",
       "      <td>Wu Lei</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>西班牙人</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>233</td>\n",
       "      <td>123</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3266</th>\n",
       "      <td>33</td>\n",
       "      <td>9</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>郜林</td>\n",
       "      <td>Gao Lin</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>广州恒大</td>\n",
       "      <td>0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>330</td>\n",
       "      <td>91</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3263</th>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>杨旭</td>\n",
       "      <td>Yang Xu</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>天津天海</td>\n",
       "      <td>0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>237</td>\n",
       "      <td>68</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3271</th>\n",
       "      <td>32</td>\n",
       "      <td>8</td>\n",
       "      <td>左脚</td>\n",
       "      <td>178</td>\n",
       "      <td>于汉超</td>\n",
       "      <td>Yu Hanchao</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>广州恒大</td>\n",
       "      <td>0</td>\n",
       "      <td>65.0</td>\n",
       "      <td>282</td>\n",
       "      <td>67</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21542</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>韩鹏</td>\n",
       "      <td>Han Peng</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Retired</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>199</td>\n",
       "      <td>52</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22006</th>\n",
       "      <td>31</td>\n",
       "      <td>9</td>\n",
       "      <td>-</td>\n",
       "      <td>185</td>\n",
       "      <td>谭龙</td>\n",
       "      <td>Tan Long</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>长春亚泰</td>\n",
       "      <td>0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>210</td>\n",
       "      <td>52</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21928</th>\n",
       "      <td>32</td>\n",
       "      <td>9</td>\n",
       "      <td>右脚</td>\n",
       "      <td>176</td>\n",
       "      <td>王永珀</td>\n",
       "      <td>Wang Yongpo</td>\n",
       "      <td>中国</td>\n",
       "      <td>中场</td>\n",
       "      <td>天津天海</td>\n",
       "      <td>0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>260</td>\n",
       "      <td>52</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21907</th>\n",
       "      <td>28</td>\n",
       "      <td>25</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>张稀哲</td>\n",
       "      <td>Zhang Xizhe</td>\n",
       "      <td>中国</td>\n",
       "      <td>中场</td>\n",
       "      <td>北京国安</td>\n",
       "      <td>0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>253</td>\n",
       "      <td>48</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21557</th>\n",
       "      <td>31</td>\n",
       "      <td>5</td>\n",
       "      <td>右脚</td>\n",
       "      <td>182</td>\n",
       "      <td>于大宝</td>\n",
       "      <td>Yu Dabao</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>北京国安</td>\n",
       "      <td>0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>264</td>\n",
       "      <td>47</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21888</th>\n",
       "      <td>29</td>\n",
       "      <td>3</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>董学升</td>\n",
       "      <td>Dong Xuesheng</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>河北华夏</td>\n",
       "      <td>0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>171</td>\n",
       "      <td>42</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       age  games_played habit_foot height name        name_en nationality  \\\n",
       "3262    27             0         右脚    174   武磊         Wu Lei          中国   \n",
       "3266    33             9         右脚    185   郜林        Gao Lin          中国   \n",
       "3263    31             5         右脚    188   杨旭        Yang Xu          中国   \n",
       "3271    32             8         左脚    178  于汉超     Yu Hanchao          中国   \n",
       "21542   35             0         右脚    188   韩鹏       Han Peng          中国   \n",
       "22006   31             9          -    185   谭龙       Tan Long          中国   \n",
       "21928   32             9         右脚    176  王永珀    Wang Yongpo          中国   \n",
       "21907   28            25         右脚    180  张稀哲    Zhang Xizhe          中国   \n",
       "21557   31             5         右脚    182  于大宝       Yu Dabao          中国   \n",
       "21888   29             3         右脚    186  董学升  Dong Xuesheng          中国   \n",
       "\n",
       "      position team_name  update_time  value  total_play  total_goal  \\\n",
       "3262        前锋      西班牙人            0    0.0         233         123   \n",
       "3266        前锋      广州恒大            0   75.0         330          91   \n",
       "3263        前锋      天津天海            0   15.0         237          68   \n",
       "3271        前锋      广州恒大            0   65.0         282          67   \n",
       "21542       前锋   Retired            0    2.5         199          52   \n",
       "22006       前锋      长春亚泰            0   30.0         210          52   \n",
       "21928       中场      天津天海            0   37.0         260          52   \n",
       "21907       中场      北京国安            0   80.0         253          48   \n",
       "21557       前锋      北京国安            0   47.0         264          47   \n",
       "21888       前锋      河北华夏            0   12.0         171          42   \n",
       "\n",
       "       total_assist  \n",
       "3262             67  \n",
       "3266             89  \n",
       "3263             24  \n",
       "3271             53  \n",
       "21542             9  \n",
       "22006            28  \n",
       "21928            48  \n",
       "21907            53  \n",
       "21557            33  \n",
       "21888             9  "
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#中国球员排名前10的\n",
    "data_china = data[data['nationality']=='中国']\n",
    "goal_analyse_china = data_china[col].sort_values(by='total_goal',ascending=False)[:10]\n",
    "goal_analyse_china"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"b0cb0f9b1c4f42c0bf36c0d567a0658e\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_b0cb0f9b1c4f42c0bf36c0d567a0658e = echarts.init(\n",
       "            document.getElementById('b0cb0f9b1c4f42c0bf36c0d567a0658e'), 'white', {renderer: 'canvas'});\n",
       "        var option_b0cb0f9b1c4f42c0bf36c0d567a0658e = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"bar\",\n",
       "            \"name\": \"\\u8fdb\\u7403\\u6570\",\n",
       "            \"data\": [\n",
       "                600,\n",
       "                598,\n",
       "                428,\n",
       "                385,\n",
       "                384,\n",
       "                348,\n",
       "                344,\n",
       "                333,\n",
       "                315,\n",
       "                310,\n",
       "                123,\n",
       "                91,\n",
       "                68,\n",
       "                67,\n",
       "                52,\n",
       "                52,\n",
       "                52,\n",
       "                48,\n",
       "                47,\n",
       "                42\n",
       "            ],\n",
       "            \"barCategoryGap\": \"20%\",\n",
       "            \"label\": {\n",
       "                \"show\": true,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u8fdb\\u7403\\u6570\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"\\u8fdb\\u7403\\u6570\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"yAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            },\n",
       "            \"data\": [\n",
       "                \"C\\u7f57\",\n",
       "                \"\\u6885\\u897f\",\n",
       "                \"\\u4f0a\\u5e03\",\n",
       "                \"\\u83b1\\u4e07\\u591a\\u592b\\u65af\\u57fa\",\n",
       "                \"\\u82cf\\u4e9a\\u96f7\\u65af\",\n",
       "                \"\\u585e\\u5c14\\u5409\\u5965-\\u963f\\u572d\\u7f57\",\n",
       "                \"\\u4ea8\\u7279\\u62c9\\u5c14\",\n",
       "                \"\\u5361\\u74e6\\u5c3c\",\n",
       "                \"\\u6bd4\\u5229\\u4e9a\",\n",
       "                \"\\u6208\\u9ea6\\u65af\",\n",
       "                \"\\u6b66\\u78ca\",\n",
       "                \"\\u90dc\\u6797\",\n",
       "                \"\\u6768\\u65ed\",\n",
       "                \"\\u4e8e\\u6c49\\u8d85\",\n",
       "                \"\\u97e9\\u9e4f\",\n",
       "                \"\\u8c2d\\u9f99\",\n",
       "                \"\\u738b\\u6c38\\u73c0\",\n",
       "                \"\\u5f20\\u7a00\\u54f2\",\n",
       "                \"\\u4e8e\\u5927\\u5b9d\",\n",
       "                \"\\u8463\\u5b66\\u5347\"\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"xAxis\": [\n",
       "        {\n",
       "            \"show\": true,\n",
       "            \"scale\": false,\n",
       "            \"nameLocation\": \"end\",\n",
       "            \"nameGap\": 15,\n",
       "            \"gridIndex\": 0,\n",
       "            \"inverse\": false,\n",
       "            \"splitLine\": {\n",
       "                \"show\": false,\n",
       "                \"lineStyle\": {\n",
       "                    \"width\": 1,\n",
       "                    \"opacity\": 1,\n",
       "                    \"curveness\": 0,\n",
       "                    \"type\": \"solid\"\n",
       "                }\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u4e2d\\u56fd\\u7403\\u5458\\u4e0e\\u4e16\\u754c\\u7403\\u5458\\u7684\\u8fdb\\u7403\\u6570\\u5bf9\\u6bd4\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "        chart_b0cb0f9b1c4f42c0bf36c0d567a0658e.setOption(option_b0cb0f9b1c4f42c0bf36c0d567a0658e);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x10ca6f470>"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#合并中国前10和世界前10\n",
    "goal = goal_analyse[:10].append(goal_analyse_china)\n",
    "\n",
    "bar = (\n",
    "    Bar()\n",
    "    .add_xaxis(goal.name.tolist())\n",
    "    .add_yaxis(\"进球数\", goal.total_goal.tolist())\n",
    "    .reversal_axis()\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"中国球员与世界球员的进球数对比\"))\n",
    ")\n",
    "bar.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>games_played</th>\n",
       "      <th>habit_foot</th>\n",
       "      <th>height</th>\n",
       "      <th>name</th>\n",
       "      <th>name_en</th>\n",
       "      <th>nationality</th>\n",
       "      <th>position</th>\n",
       "      <th>team_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>total_play</th>\n",
       "      <th>total_goal</th>\n",
       "      <th>total_assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3262</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>武磊</td>\n",
       "      <td>Wu Lei</td>\n",
       "      <td>中国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>西班牙人</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>233</td>\n",
       "      <td>123</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      age  games_played habit_foot height name name_en nationality position  \\\n",
       "3262   27             0         右脚    174   武磊  Wu Lei          中国       前锋   \n",
       "\n",
       "     team_name  update_time  value  total_play  total_goal  total_assist  \n",
       "3262      西班牙人            0    0.0         233         123            67  "
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#查看中国进球数第一的武磊排名世界第几\n",
    "data_goal_rank = data[col].sort_values(by='total_goal',ascending=False)\n",
    "data_goal_rank[data_goal_rank.name == '武磊']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>games_played</th>\n",
       "      <th>habit_foot</th>\n",
       "      <th>height</th>\n",
       "      <th>name</th>\n",
       "      <th>name_en</th>\n",
       "      <th>nationality</th>\n",
       "      <th>position</th>\n",
       "      <th>team_name</th>\n",
       "      <th>update_time</th>\n",
       "      <th>value</th>\n",
       "      <th>total_play</th>\n",
       "      <th>total_goal</th>\n",
       "      <th>total_assist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2208</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>C罗</td>\n",
       "      <td>Cristiano Ronaldo</td>\n",
       "      <td>葡萄牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>尤文图斯</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>800</td>\n",
       "      <td>600</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>31</td>\n",
       "      <td>35</td>\n",
       "      <td>左脚</td>\n",
       "      <td>170</td>\n",
       "      <td>梅西</td>\n",
       "      <td>Lionel Messi</td>\n",
       "      <td>阿根廷,西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>巴塞罗那</td>\n",
       "      <td>0</td>\n",
       "      <td>18000.00</td>\n",
       "      <td>682</td>\n",
       "      <td>598</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1679</th>\n",
       "      <td>37</td>\n",
       "      <td>6</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>195</td>\n",
       "      <td>伊布</td>\n",
       "      <td>Zlatan Ibrahimovic</td>\n",
       "      <td>瑞典</td>\n",
       "      <td>前锋</td>\n",
       "      <td>洛杉矶银河</td>\n",
       "      <td>0</td>\n",
       "      <td>500.00</td>\n",
       "      <td>712</td>\n",
       "      <td>428</td>\n",
       "      <td>167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2895</th>\n",
       "      <td>30</td>\n",
       "      <td>29</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>莱万多夫斯基</td>\n",
       "      <td>Robert Lewandowski</td>\n",
       "      <td>波兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>9000.00</td>\n",
       "      <td>597</td>\n",
       "      <td>385</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3012</th>\n",
       "      <td>32</td>\n",
       "      <td>31</td>\n",
       "      <td>右脚</td>\n",
       "      <td>182</td>\n",
       "      <td>苏亚雷斯</td>\n",
       "      <td>Luis Suárez</td>\n",
       "      <td>乌拉圭,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>巴塞罗那</td>\n",
       "      <td>0</td>\n",
       "      <td>8500.00</td>\n",
       "      <td>574</td>\n",
       "      <td>384</td>\n",
       "      <td>217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>30</td>\n",
       "      <td>25</td>\n",
       "      <td>右脚</td>\n",
       "      <td>173</td>\n",
       "      <td>塞尔吉奥-阿圭罗</td>\n",
       "      <td>Sergio Agüero</td>\n",
       "      <td>阿根廷,西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>曼城</td>\n",
       "      <td>0</td>\n",
       "      <td>7500.00</td>\n",
       "      <td>602</td>\n",
       "      <td>348</td>\n",
       "      <td>115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11651</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>亨特拉尔</td>\n",
       "      <td>Klaas Huntelaar</td>\n",
       "      <td>荷兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>阿贾克斯</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>602</td>\n",
       "      <td>344</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3009</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>卡瓦尼</td>\n",
       "      <td>Edinson Cavani</td>\n",
       "      <td>乌拉圭,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>巴黎圣日耳曼</td>\n",
       "      <td>0</td>\n",
       "      <td>6000.00</td>\n",
       "      <td>530</td>\n",
       "      <td>333</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19653</th>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>比利亚</td>\n",
       "      <td>David Villa</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>神户胜利船</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>618</td>\n",
       "      <td>315</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>33</td>\n",
       "      <td>16</td>\n",
       "      <td>右脚</td>\n",
       "      <td>189</td>\n",
       "      <td>戈麦斯</td>\n",
       "      <td>Mario Gomez</td>\n",
       "      <td>德国,西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>斯图加特</td>\n",
       "      <td>0</td>\n",
       "      <td>600.00</td>\n",
       "      <td>570</td>\n",
       "      <td>310</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32587</th>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>176</td>\n",
       "      <td>鲁尼</td>\n",
       "      <td>Wayne Rooney</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>华盛顿联</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>696</td>\n",
       "      <td>295</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>伊瓜因</td>\n",
       "      <td>Gonzalo Higuaín</td>\n",
       "      <td>阿根廷,法国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>切尔西</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>583</td>\n",
       "      <td>293</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9887</th>\n",
       "      <td>36</td>\n",
       "      <td>31</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>M.罗巴克</td>\n",
       "      <td>Marcin Robak</td>\n",
       "      <td>波兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>斯拉斯克</td>\n",
       "      <td>0</td>\n",
       "      <td>25.00</td>\n",
       "      <td>630</td>\n",
       "      <td>289</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2207</th>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>本泽马</td>\n",
       "      <td>Karim Benzema</td>\n",
       "      <td>法国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>皇家马德里</td>\n",
       "      <td>0</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>611</td>\n",
       "      <td>288</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3325</th>\n",
       "      <td>32</td>\n",
       "      <td>9</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>胡尔克</td>\n",
       "      <td>Givanildo Vieira de</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>上海上港</td>\n",
       "      <td>0</td>\n",
       "      <td>2100.00</td>\n",
       "      <td>526</td>\n",
       "      <td>281</td>\n",
       "      <td>170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7245</th>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>克拉迪奥-皮萨罗</td>\n",
       "      <td>Claudio Pizarro</td>\n",
       "      <td>秘鲁,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>不莱梅</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>673</td>\n",
       "      <td>277</td>\n",
       "      <td>111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6840</th>\n",
       "      <td>33</td>\n",
       "      <td>34</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>193</td>\n",
       "      <td>哲科</td>\n",
       "      <td>Edin Dzeko</td>\n",
       "      <td>Bosnia-Herzegovina</td>\n",
       "      <td>前锋</td>\n",
       "      <td>罗马</td>\n",
       "      <td>0</td>\n",
       "      <td>2200.00</td>\n",
       "      <td>595</td>\n",
       "      <td>275</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15158</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>183</td>\n",
       "      <td>范佩西</td>\n",
       "      <td>Robin van Persie</td>\n",
       "      <td>荷兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>费耶诺德</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>593</td>\n",
       "      <td>274</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8878</th>\n",
       "      <td>33</td>\n",
       "      <td>25</td>\n",
       "      <td>右脚</td>\n",
       "      <td>177</td>\n",
       "      <td>法尔考</td>\n",
       "      <td>Radamel Falcao Garcí</td>\n",
       "      <td>哥伦比亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>摩纳哥</td>\n",
       "      <td>0</td>\n",
       "      <td>1500.00</td>\n",
       "      <td>456</td>\n",
       "      <td>268</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2305</th>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>171</td>\n",
       "      <td>杰梅因-迪福</td>\n",
       "      <td>Jermain Defoe</td>\n",
       "      <td>英格兰,圣卢西亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>格拉斯哥流浪者</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>655</td>\n",
       "      <td>249</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21903</th>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>J.索里亚诺</td>\n",
       "      <td>Jonatan Soriano</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利雅得新月</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>361</td>\n",
       "      <td>248</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21265</th>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>前田辽一</td>\n",
       "      <td>Ryoichi Maeda</td>\n",
       "      <td>日本</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FC Gifu</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>746</td>\n",
       "      <td>248</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15212</th>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>184</td>\n",
       "      <td>戈米</td>\n",
       "      <td>Batefimbi Gomis</td>\n",
       "      <td>法国,塞内加尔</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利雅得新月</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>602</td>\n",
       "      <td>244</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25539</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>182</td>\n",
       "      <td>Jonas</td>\n",
       "      <td>Jonas</td>\n",
       "      <td>巴西,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>本菲卡</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>454</td>\n",
       "      <td>240</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25461</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>左右脚</td>\n",
       "      <td>172</td>\n",
       "      <td>Vágner Love</td>\n",
       "      <td>Vágner Love</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Corinthians Sao Paulo</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>477</td>\n",
       "      <td>240</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3084</th>\n",
       "      <td>33</td>\n",
       "      <td>31</td>\n",
       "      <td>右脚</td>\n",
       "      <td>175</td>\n",
       "      <td>夏普</td>\n",
       "      <td>Billy Sharp</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>谢菲尔德联</td>\n",
       "      <td>0</td>\n",
       "      <td>100.00</td>\n",
       "      <td>541</td>\n",
       "      <td>237</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3226</th>\n",
       "      <td>29</td>\n",
       "      <td>11</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>奥巴梅扬</td>\n",
       "      <td>Pierre-Emerick Aubam</td>\n",
       "      <td>加蓬,法国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>阿森纳</td>\n",
       "      <td>0</td>\n",
       "      <td>6500.00</td>\n",
       "      <td>463</td>\n",
       "      <td>230</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27968</th>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>187</td>\n",
       "      <td>André-Pierre Gignac</td>\n",
       "      <td>André-Pierre Gignac</td>\n",
       "      <td>法国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>老虎大学</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>535</td>\n",
       "      <td>230</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>29</td>\n",
       "      <td>28</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>托马斯-穆勒</td>\n",
       "      <td>Thomas Müller</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>拜仁慕尼黑</td>\n",
       "      <td>0</td>\n",
       "      <td>5500.00</td>\n",
       "      <td>569</td>\n",
       "      <td>227</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32397</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>186</td>\n",
       "      <td>Daniel Frahn</td>\n",
       "      <td>Daniel Frahn</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Chemnitzer FC</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>447</td>\n",
       "      <td>224</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28848</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>181</td>\n",
       "      <td>Arouna Koné</td>\n",
       "      <td>Arouna Koné</td>\n",
       "      <td>科特迪瓦</td>\n",
       "      <td>前锋</td>\n",
       "      <td>锡瓦斯体育</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>425</td>\n",
       "      <td>128</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23181</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>196</td>\n",
       "      <td>久巴</td>\n",
       "      <td>Artem Dzyuba</td>\n",
       "      <td>俄罗斯</td>\n",
       "      <td>前锋</td>\n",
       "      <td>泽尼特</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>383</td>\n",
       "      <td>128</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "      <td>右脚</td>\n",
       "      <td>174</td>\n",
       "      <td>萨迪奥-马内</td>\n",
       "      <td>Sadio Mané</td>\n",
       "      <td>塞内加尔</td>\n",
       "      <td>前锋</td>\n",
       "      <td>利物浦</td>\n",
       "      <td>0</td>\n",
       "      <td>6000.00</td>\n",
       "      <td>300</td>\n",
       "      <td>128</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1722</th>\n",
       "      <td>28</td>\n",
       "      <td>30</td>\n",
       "      <td>右脚</td>\n",
       "      <td>190</td>\n",
       "      <td>克里斯蒂安-本特克</td>\n",
       "      <td>Christian Benteke</td>\n",
       "      <td>比利时,DR Congo</td>\n",
       "      <td>前锋</td>\n",
       "      <td>水晶宫</td>\n",
       "      <td>0</td>\n",
       "      <td>2200.00</td>\n",
       "      <td>367</td>\n",
       "      <td>127</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21885</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>170</td>\n",
       "      <td>阿洛伊西奥</td>\n",
       "      <td>Aloisio dos Santos G</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>梅县铁汉生态</td>\n",
       "      <td>0</td>\n",
       "      <td>123456.78</td>\n",
       "      <td>287</td>\n",
       "      <td>127</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6929</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>帕沃莱蒂</td>\n",
       "      <td>Leonardo Pavoletti</td>\n",
       "      <td>意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>卡利亚里</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>291</td>\n",
       "      <td>127</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3362</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>191</td>\n",
       "      <td>内奇德</td>\n",
       "      <td>Tomas Necid</td>\n",
       "      <td>捷克</td>\n",
       "      <td>前锋</td>\n",
       "      <td>海牙</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>413</td>\n",
       "      <td>127</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1161</th>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>雷德</td>\n",
       "      <td>Reuben Reid</td>\n",
       "      <td>英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>格兰森林流浪</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>468</td>\n",
       "      <td>127</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7009</th>\n",
       "      <td>34</td>\n",
       "      <td>23</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>马特里</td>\n",
       "      <td>Alessandro Matri</td>\n",
       "      <td>意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>萨索洛</td>\n",
       "      <td>0</td>\n",
       "      <td>70.00</td>\n",
       "      <td>487</td>\n",
       "      <td>127</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>31</td>\n",
       "      <td>29</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>迪马利亚</td>\n",
       "      <td>Ángel Di María</td>\n",
       "      <td>阿根廷,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>巴黎圣日耳曼</td>\n",
       "      <td>0</td>\n",
       "      <td>4000.00</td>\n",
       "      <td>550</td>\n",
       "      <td>127</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22003</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>伊哈洛</td>\n",
       "      <td>Odion Ighalo</td>\n",
       "      <td>尼日利亚,意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>上海申花</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>314</td>\n",
       "      <td>127</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21869</th>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>172</td>\n",
       "      <td>穆里奇</td>\n",
       "      <td>Muriqui</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>石家庄永昌</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>279</td>\n",
       "      <td>126</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18181</th>\n",
       "      <td>32</td>\n",
       "      <td>24</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>科奥格</td>\n",
       "      <td>Andy Keogh</td>\n",
       "      <td>爱尔兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>珀斯光荣</td>\n",
       "      <td>0</td>\n",
       "      <td>75.00</td>\n",
       "      <td>507</td>\n",
       "      <td>126</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3367</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>182</td>\n",
       "      <td>多茨卡尔</td>\n",
       "      <td>Borek Dockal</td>\n",
       "      <td>捷克</td>\n",
       "      <td>中场</td>\n",
       "      <td>AC Sparta Praha</td>\n",
       "      <td>0</td>\n",
       "      <td>200.00</td>\n",
       "      <td>607</td>\n",
       "      <td>126</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3988</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>190</td>\n",
       "      <td>伊万·桑蒂尼</td>\n",
       "      <td>Ivan Santini</td>\n",
       "      <td>克罗地亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>安德莱赫特</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>349</td>\n",
       "      <td>126</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14068</th>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>188</td>\n",
       "      <td>帕特里克·莫腾森</td>\n",
       "      <td>Patrick Mortensen</td>\n",
       "      <td>丹麦</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aarhus GF</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>313</td>\n",
       "      <td>126</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17796</th>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>189</td>\n",
       "      <td>巴尔克斯</td>\n",
       "      <td>Hernán Barcos</td>\n",
       "      <td>阿根廷</td>\n",
       "      <td>前锋</td>\n",
       "      <td>麦德林国民竞技</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>336</td>\n",
       "      <td>126</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3114</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>175</td>\n",
       "      <td>香川真司</td>\n",
       "      <td>Shinji Kagawa</td>\n",
       "      <td>日本</td>\n",
       "      <td>中场</td>\n",
       "      <td>贝西克塔斯</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>411</td>\n",
       "      <td>126</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21624</th>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>185</td>\n",
       "      <td>穆伦加</td>\n",
       "      <td>Jacob Mulenga</td>\n",
       "      <td>赞比亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>辽宁沈阳宏运</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>373</td>\n",
       "      <td>126</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5385</th>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>175</td>\n",
       "      <td>S.帕瓦洛斯基</td>\n",
       "      <td>Szymon Pawlowski</td>\n",
       "      <td>波兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>索斯诺维茨</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>623</td>\n",
       "      <td>125</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26299</th>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>193</td>\n",
       "      <td>Roque Santa Cruz</td>\n",
       "      <td>Roque Santa Cruz</td>\n",
       "      <td>巴拉圭</td>\n",
       "      <td>前锋</td>\n",
       "      <td>亚松森奥林匹亚</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>513</td>\n",
       "      <td>125</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16443</th>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>177</td>\n",
       "      <td>爱德华多</td>\n",
       "      <td>Eduardo Alves da Sil</td>\n",
       "      <td>克罗地亚</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Without Club</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>348</td>\n",
       "      <td>125</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3932</th>\n",
       "      <td>31</td>\n",
       "      <td>32</td>\n",
       "      <td>左脚</td>\n",
       "      <td>180</td>\n",
       "      <td>亨宁斯</td>\n",
       "      <td>Rouwen Hennings</td>\n",
       "      <td>德国</td>\n",
       "      <td>前锋</td>\n",
       "      <td>杜塞尔多夫</td>\n",
       "      <td>0</td>\n",
       "      <td>150.00</td>\n",
       "      <td>442</td>\n",
       "      <td>125</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3324</th>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>178</td>\n",
       "      <td>迭戈·塔尔德利</td>\n",
       "      <td>Diego Tardelli Marti</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>格雷米奥</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>356</td>\n",
       "      <td>125</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24576</th>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>180</td>\n",
       "      <td>Will Grigg</td>\n",
       "      <td>Will Grigg</td>\n",
       "      <td>北爱尔兰,英格兰</td>\n",
       "      <td>前锋</td>\n",
       "      <td>桑德兰</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>363</td>\n",
       "      <td>125</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30952</th>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>186</td>\n",
       "      <td>Marco Borriello</td>\n",
       "      <td>Marco Borriello</td>\n",
       "      <td>意大利</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Retired</td>\n",
       "      <td>0</td>\n",
       "      <td>40.00</td>\n",
       "      <td>433</td>\n",
       "      <td>124</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28998</th>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>右脚</td>\n",
       "      <td>183</td>\n",
       "      <td>Bogdan Stancu</td>\n",
       "      <td>Bogdan Stancu</td>\n",
       "      <td>罗马尼亚</td>\n",
       "      <td>前锋</td>\n",
       "      <td>Genclerbirligi Ankara</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>391</td>\n",
       "      <td>124</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1687</th>\n",
       "      <td>31</td>\n",
       "      <td>27</td>\n",
       "      <td>左脚</td>\n",
       "      <td>170</td>\n",
       "      <td>胡安-马塔</td>\n",
       "      <td>Juan Mata</td>\n",
       "      <td>西班牙</td>\n",
       "      <td>中场</td>\n",
       "      <td>曼联</td>\n",
       "      <td>0</td>\n",
       "      <td>3000.00</td>\n",
       "      <td>527</td>\n",
       "      <td>124</td>\n",
       "      <td>147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28973</th>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>左脚</td>\n",
       "      <td>172</td>\n",
       "      <td>Heberty</td>\n",
       "      <td>Heberty</td>\n",
       "      <td>巴西</td>\n",
       "      <td>前锋</td>\n",
       "      <td>SCG Muangthong United</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>232</td>\n",
       "      <td>124</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21147</th>\n",
       "      <td>34</td>\n",
       "      <td>13</td>\n",
       "      <td>右脚</td>\n",
       "      <td>173</td>\n",
       "      <td>石原直树</td>\n",
       "      <td>Naoki Ishihara</td>\n",
       "      <td>日本</td>\n",
       "      <td>前锋</td>\n",
       "      <td>仙台维加泰</td>\n",
       "      <td>0</td>\n",
       "      <td>50.00</td>\n",
       "      <td>501</td>\n",
       "      <td>124</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>239 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       age  games_played habit_foot height                 name  \\\n",
       "2208    34             0        左右脚    187                   C罗   \n",
       "53      31            35         左脚    170                   梅西   \n",
       "1679    37             6        左右脚    195                   伊布   \n",
       "2895    30            29         右脚    185               莱万多夫斯基   \n",
       "3012    32            31         右脚    182                 苏亚雷斯   \n",
       "54      30            25         右脚    173             塞尔吉奥-阿圭罗   \n",
       "11651   35             0         右脚    186                 亨特拉尔   \n",
       "3009    32            32         右脚    184                  卡瓦尼   \n",
       "19653   37             0        左右脚    174                  比利亚   \n",
       "3       33            16         右脚    189                  戈麦斯   \n",
       "32587   33             0         右脚    176                   鲁尼   \n",
       "55      31             0         右脚    184                  伊瓜因   \n",
       "9887    36            31         右脚    184                M.罗巴克   \n",
       "2207    31            29        左右脚    185                  本泽马   \n",
       "3325    32             9         左脚    180                  胡尔克   \n",
       "7245    40             0         右脚    184             克拉迪奥-皮萨罗   \n",
       "6840    33            34        左右脚    193                   哲科   \n",
       "15158   35             0         左脚    183                  范佩西   \n",
       "8878    33            25         右脚    177                  法尔考   \n",
       "2305    36             0         右脚    171               杰梅因-迪福   \n",
       "21903   33             0         右脚    180               J.索里亚诺   \n",
       "21265   37             0         右脚    184                 前田辽一   \n",
       "15212   33             0         右脚    184                   戈米   \n",
       "25539   35             0         右脚    182                Jonas   \n",
       "25461   34             0        左右脚    172          Vágner Love   \n",
       "3084    33            31         右脚    175                   夏普   \n",
       "3226    29            11         右脚    187                 奥巴梅扬   \n",
       "27968   33             0         右脚    187  André-Pierre Gignac   \n",
       "1       29            28         右脚    186               托马斯-穆勒   \n",
       "32397   31             0         右脚    186         Daniel Frahn   \n",
       "...    ...           ...        ...    ...                  ...   \n",
       "28848   35             0         右脚    181          Arouna Koné   \n",
       "23181   30             0         右脚    196                   久巴   \n",
       "25      27            28         右脚    174               萨迪奥-马内   \n",
       "1722    28            30         右脚    190            克里斯蒂安-本特克   \n",
       "21885   30             0         右脚    170                阿洛伊西奥   \n",
       "6929    30             0         右脚    188                 帕沃莱蒂   \n",
       "3362    29             0         右脚    191                  内奇德   \n",
       "1161    30            21         右脚    183                   雷德   \n",
       "7009    34            23         右脚    183                  马特里   \n",
       "56      31            29         左脚    180                 迪马利亚   \n",
       "22003   29             0         右脚    183                  伊哈洛   \n",
       "21869   32             0         右脚    172                  穆里奇   \n",
       "18181   32            24         右脚    183                  科奥格   \n",
       "3367    30             0         右脚    182                 多茨卡尔   \n",
       "3988    29             0         右脚    190               伊万·桑蒂尼   \n",
       "14068   29             0         右脚    188             帕特里克·莫腾森   \n",
       "17796   34             0         右脚    189                 巴尔克斯   \n",
       "3114    30             0         右脚    175                 香川真司   \n",
       "21624   35             0         右脚    185                  穆伦加   \n",
       "5385    32             0         右脚    175              S.帕瓦洛斯基   \n",
       "26299   37             0         右脚    193     Roque Santa Cruz   \n",
       "16443   36             0         左脚    177                 爱德华多   \n",
       "3932    31            32         左脚    180                  亨宁斯   \n",
       "3324    33             0         右脚    178              迭戈·塔尔德利   \n",
       "24576   27             0         右脚    180           Will Grigg   \n",
       "30952   36             0         左脚    186      Marco Borriello   \n",
       "28998   31             0         右脚    183        Bogdan Stancu   \n",
       "1687    31            27         左脚    170                胡安-马塔   \n",
       "28973   30             0         左脚    172              Heberty   \n",
       "21147   34            13         右脚    173                 石原直树   \n",
       "\n",
       "                    name_en         nationality position  \\\n",
       "2208      Cristiano Ronaldo                 葡萄牙       前锋   \n",
       "53             Lionel Messi             阿根廷,西班牙       前锋   \n",
       "1679     Zlatan Ibrahimovic                  瑞典       前锋   \n",
       "2895     Robert Lewandowski                  波兰       前锋   \n",
       "3012            Luis Suárez             乌拉圭,意大利       前锋   \n",
       "54            Sergio Agüero             阿根廷,西班牙       前锋   \n",
       "11651       Klaas Huntelaar                  荷兰       前锋   \n",
       "3009         Edinson Cavani             乌拉圭,意大利       前锋   \n",
       "19653           David Villa                 西班牙       前锋   \n",
       "3               Mario Gomez              德国,西班牙       前锋   \n",
       "32587          Wayne Rooney                 英格兰       前锋   \n",
       "55          Gonzalo Higuaín              阿根廷,法国       前锋   \n",
       "9887           Marcin Robak                  波兰       前锋   \n",
       "2207          Karim Benzema                  法国       前锋   \n",
       "3325   Givanildo Vieira de                   巴西       前锋   \n",
       "7245        Claudio Pizarro              秘鲁,意大利       前锋   \n",
       "6840             Edin Dzeko  Bosnia-Herzegovina       前锋   \n",
       "15158      Robin van Persie                  荷兰       前锋   \n",
       "8878   Radamel Falcao Garcí                哥伦比亚       前锋   \n",
       "2305          Jermain Defoe            英格兰,圣卢西亚       前锋   \n",
       "21903       Jonatan Soriano                 西班牙       前锋   \n",
       "21265         Ryoichi Maeda                  日本      NaN   \n",
       "15212       Batefimbi Gomis             法国,塞内加尔       前锋   \n",
       "25539                 Jonas              巴西,意大利       前锋   \n",
       "25461           Vágner Love                  巴西       前锋   \n",
       "3084            Billy Sharp                 英格兰       前锋   \n",
       "3226   Pierre-Emerick Aubam               加蓬,法国       前锋   \n",
       "27968   André-Pierre Gignac                  法国       前锋   \n",
       "1             Thomas Müller                  德国       前锋   \n",
       "32397          Daniel Frahn                  德国       前锋   \n",
       "...                     ...                 ...      ...   \n",
       "28848           Arouna Koné                科特迪瓦       前锋   \n",
       "23181          Artem Dzyuba                 俄罗斯       前锋   \n",
       "25               Sadio Mané                塞内加尔       前锋   \n",
       "1722      Christian Benteke        比利时,DR Congo       前锋   \n",
       "21885  Aloisio dos Santos G                  巴西       前锋   \n",
       "6929     Leonardo Pavoletti                 意大利       前锋   \n",
       "3362            Tomas Necid                  捷克       前锋   \n",
       "1161            Reuben Reid                 英格兰       前锋   \n",
       "7009       Alessandro Matri                 意大利       前锋   \n",
       "56           Ángel Di María             阿根廷,意大利       前锋   \n",
       "22003          Odion Ighalo            尼日利亚,意大利       前锋   \n",
       "21869               Muriqui                  巴西       前锋   \n",
       "18181            Andy Keogh                 爱尔兰       前锋   \n",
       "3367           Borek Dockal                  捷克       中场   \n",
       "3988           Ivan Santini                克罗地亚       前锋   \n",
       "14068     Patrick Mortensen                  丹麦      NaN   \n",
       "17796         Hernán Barcos                 阿根廷       前锋   \n",
       "3114          Shinji Kagawa                  日本       中场   \n",
       "21624         Jacob Mulenga                 赞比亚       前锋   \n",
       "5385       Szymon Pawlowski                  波兰       前锋   \n",
       "26299      Roque Santa Cruz                 巴拉圭       前锋   \n",
       "16443  Eduardo Alves da Sil                克罗地亚      NaN   \n",
       "3932        Rouwen Hennings                  德国       前锋   \n",
       "3324   Diego Tardelli Marti                  巴西       前锋   \n",
       "24576            Will Grigg            北爱尔兰,英格兰       前锋   \n",
       "30952       Marco Borriello                 意大利       前锋   \n",
       "28998         Bogdan Stancu                罗马尼亚       前锋   \n",
       "1687              Juan Mata                 西班牙       中场   \n",
       "28973               Heberty                  巴西       前锋   \n",
       "21147        Naoki Ishihara                  日本       前锋   \n",
       "\n",
       "                   team_name  update_time      value  total_play  total_goal  \\\n",
       "2208                    尤文图斯            0       0.00         800         600   \n",
       "53                      巴塞罗那            0   18000.00         682         598   \n",
       "1679                   洛杉矶银河            0     500.00         712         428   \n",
       "2895                   拜仁慕尼黑            0    9000.00         597         385   \n",
       "3012                    巴塞罗那            0    8500.00         574         384   \n",
       "54                        曼城            0    7500.00         602         348   \n",
       "11651                   阿贾克斯            0       0.00         602         344   \n",
       "3009                  巴黎圣日耳曼            0    6000.00         530         333   \n",
       "19653                  神户胜利船            0       0.00         618         315   \n",
       "3                       斯图加特            0     600.00         570         310   \n",
       "32587                   华盛顿联            0       0.00         696         295   \n",
       "55                       切尔西            0       0.00         583         293   \n",
       "9887                    斯拉斯克            0      25.00         630         289   \n",
       "2207                   皇家马德里            0    5000.00         611         288   \n",
       "3325                    上海上港            0    2100.00         526         281   \n",
       "7245                     不莱梅            0       0.00         673         277   \n",
       "6840                      罗马            0    2200.00         595         275   \n",
       "15158                   费耶诺德            0       0.00         593         274   \n",
       "8878                     摩纳哥            0    1500.00         456         268   \n",
       "2305                 格拉斯哥流浪者            0       0.00         655         249   \n",
       "21903                  利雅得新月            0       0.00         361         248   \n",
       "21265                FC Gifu            0       0.00         746         248   \n",
       "15212                  利雅得新月            0       0.00         602         244   \n",
       "25539                    本菲卡            0       0.00         454         240   \n",
       "25461  Corinthians Sao Paulo            0       0.00         477         240   \n",
       "3084                   谢菲尔德联            0     100.00         541         237   \n",
       "3226                     阿森纳            0    6500.00         463         230   \n",
       "27968                   老虎大学            0       0.00         535         230   \n",
       "1                      拜仁慕尼黑            0    5500.00         569         227   \n",
       "32397          Chemnitzer FC            0       0.00         447         224   \n",
       "...                      ...          ...        ...         ...         ...   \n",
       "28848                  锡瓦斯体育            0       0.00         425         128   \n",
       "23181                    泽尼特            0       0.00         383         128   \n",
       "25                       利物浦            0    6000.00         300         128   \n",
       "1722                     水晶宫            0    2200.00         367         127   \n",
       "21885                 梅县铁汉生态            0  123456.78         287         127   \n",
       "6929                    卡利亚里            0       0.00         291         127   \n",
       "3362                      海牙            0       0.00         413         127   \n",
       "1161                  格兰森林流浪            0      50.00         468         127   \n",
       "7009                     萨索洛            0      70.00         487         127   \n",
       "56                    巴黎圣日耳曼            0    4000.00         550         127   \n",
       "22003                   上海申花            0       0.00         314         127   \n",
       "21869                  石家庄永昌            0       0.00         279         126   \n",
       "18181                   珀斯光荣            0      75.00         507         126   \n",
       "3367         AC Sparta Praha            0     200.00         607         126   \n",
       "3988                   安德莱赫特            0       0.00         349         126   \n",
       "14068              Aarhus GF            0      50.00         313         126   \n",
       "17796                麦德林国民竞技            0       0.00         336         126   \n",
       "3114                   贝西克塔斯            0       0.00         411         126   \n",
       "21624                 辽宁沈阳宏运            0       0.00         373         126   \n",
       "5385                   索斯诺维茨            0       0.00         623         125   \n",
       "26299                亚松森奥林匹亚            0       0.00         513         125   \n",
       "16443           Without Club            0       0.00         348         125   \n",
       "3932                   杜塞尔多夫            0     150.00         442         125   \n",
       "3324                    格雷米奥            0       0.00         356         125   \n",
       "24576                    桑德兰            0       0.00         363         125   \n",
       "30952                Retired            0      40.00         433         124   \n",
       "28998  Genclerbirligi Ankara            0       0.00         391         124   \n",
       "1687                      曼联            0    3000.00         527         124   \n",
       "28973  SCG Muangthong United            0       0.00         232         124   \n",
       "21147                  仙台维加泰            0      50.00         501         124   \n",
       "\n",
       "       total_assist  \n",
       "2208            213  \n",
       "53              240  \n",
       "1679            167  \n",
       "2895            124  \n",
       "3012            217  \n",
       "54              115  \n",
       "11651            82  \n",
       "3009             65  \n",
       "19653            74  \n",
       "3                70  \n",
       "32587           158  \n",
       "55               97  \n",
       "9887             61  \n",
       "2207            150  \n",
       "3325            170  \n",
       "7245            111  \n",
       "6840            112  \n",
       "15158            98  \n",
       "8878             51  \n",
       "2305             54  \n",
       "21903            82  \n",
       "21265            52  \n",
       "15212            58  \n",
       "25539            86  \n",
       "25461            83  \n",
       "3084             61  \n",
       "3226             80  \n",
       "27968            55  \n",
       "1               166  \n",
       "32397            62  \n",
       "...             ...  \n",
       "28848            56  \n",
       "23181            69  \n",
       "25               69  \n",
       "1722             53  \n",
       "21885            39  \n",
       "6929             24  \n",
       "3362             28  \n",
       "1161             41  \n",
       "7009             32  \n",
       "56              191  \n",
       "22003            25  \n",
       "21869            67  \n",
       "18181            56  \n",
       "3367            150  \n",
       "3988             23  \n",
       "14068            27  \n",
       "17796            44  \n",
       "3114             89  \n",
       "21624            38  \n",
       "5385            122  \n",
       "26299            42  \n",
       "16443            50  \n",
       "3932             60  \n",
       "3324             43  \n",
       "24576            29  \n",
       "30952            36  \n",
       "28998            36  \n",
       "1687            147  \n",
       "28973            38  \n",
       "21147            40  \n",
       "\n",
       "[239 rows x 14 columns]"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_goal_rank[data_goal_rank.total_goal>123]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "球员个人数据对比，主要对比三大球员：梅西，C罗，武磊"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts':'https://assets.pyecharts.org/assets/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "\n",
       "    <div id=\"f753508b08f1456fbb3f71abd982c0f2\" style=\"width:900px; height:500px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        var chart_f753508b08f1456fbb3f71abd982c0f2 = echarts.init(\n",
       "            document.getElementById('f753508b08f1456fbb3f71abd982c0f2'), 'white', {renderer: 'canvas'});\n",
       "        var option_f753508b08f1456fbb3f71abd982c0f2 = {\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\"\n",
       "    ],\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"radar\",\n",
       "            \"name\": \"C\\u7f57\",\n",
       "            \"data\": [\n",
       "                [\n",
       "                    184,\n",
       "                    800,\n",
       "                    600,\n",
       "                    213,\n",
       "                    38\n",
       "                ]\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"show\": false,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"itemStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"color\": \"#f9713c\"\n",
       "                }\n",
       "            },\n",
       "            \"lineStyle\": {\n",
       "                \"width\": 1,\n",
       "                \"opacity\": 1,\n",
       "                \"curveness\": 0,\n",
       "                \"type\": \"solid\"\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"rippleEffect\": {\n",
       "                \"show\": true,\n",
       "                \"brushType\": \"stroke\",\n",
       "                \"scale\": 2.5,\n",
       "                \"period\": 4\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"radar\",\n",
       "            \"name\": \"\\u6885\\u897f\",\n",
       "            \"data\": [\n",
       "                [\n",
       "                    169,\n",
       "                    682,\n",
       "                    598,\n",
       "                    240,\n",
       "                    43\n",
       "                ]\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"show\": false,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"itemStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"color\": \"#b9e4a1\"\n",
       "                }\n",
       "            },\n",
       "            \"lineStyle\": {\n",
       "                \"width\": 1,\n",
       "                \"opacity\": 1,\n",
       "                \"curveness\": 0,\n",
       "                \"type\": \"solid\"\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"rippleEffect\": {\n",
       "                \"show\": true,\n",
       "                \"brushType\": \"stroke\",\n",
       "                \"scale\": 2.5,\n",
       "                \"period\": 4\n",
       "            }\n",
       "        },\n",
       "        {\n",
       "            \"type\": \"radar\",\n",
       "            \"name\": \"\\u6b66\\u78ca\",\n",
       "            \"data\": [\n",
       "                [\n",
       "                    174,\n",
       "                    233,\n",
       "                    123,\n",
       "                    67,\n",
       "                    5\n",
       "                ]\n",
       "            ],\n",
       "            \"label\": {\n",
       "                \"show\": false,\n",
       "                \"position\": \"top\",\n",
       "                \"fontSize\": 12\n",
       "            },\n",
       "            \"itemStyle\": {\n",
       "                \"normal\": {\n",
       "                    \"color\": \"#a9713c\"\n",
       "                }\n",
       "            },\n",
       "            \"lineStyle\": {\n",
       "                \"width\": 1,\n",
       "                \"opacity\": 1,\n",
       "                \"curveness\": 0,\n",
       "                \"type\": \"solid\"\n",
       "            },\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            },\n",
       "            \"rippleEffect\": {\n",
       "                \"show\": true,\n",
       "                \"brushType\": \"stroke\",\n",
       "                \"scale\": 2.5,\n",
       "                \"period\": 4\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"C\\u7f57\",\n",
       "                \"\\u6885\\u897f\",\n",
       "                \"\\u6b66\\u78ca\"\n",
       "            ],\n",
       "            \"selected\": {\n",
       "                \"C\\u7f57\": true,\n",
       "                \"\\u6885\\u897f\": true,\n",
       "                \"\\u6b66\\u78ca\": true\n",
       "            },\n",
       "            \"show\": true\n",
       "        }\n",
       "    ],\n",
       "    \"tooltip\": {\n",
       "        \"show\": true,\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"radar\": {\n",
       "        \"indicator\": [\n",
       "            {\n",
       "                \"name\": \"\\u8eab\\u9ad8\",\n",
       "                \"max\": 200\n",
       "            },\n",
       "            {\n",
       "                \"name\": \"\\u51fa\\u573a\\u6b21\\u6570\",\n",
       "                \"max\": 800\n",
       "            },\n",
       "            {\n",
       "                \"name\": \"\\u8fdb\\u7403\\u6570\",\n",
       "                \"max\": 600\n",
       "            },\n",
       "            {\n",
       "                \"name\": \"\\u52a9\\u653b\\u6570\",\n",
       "                \"max\": 240\n",
       "            },\n",
       "            {\n",
       "                \"name\": \"\\u51a0\\u519b\\u6570\",\n",
       "                \"max\": 50\n",
       "            }\n",
       "        ],\n",
       "        \"name\": {\n",
       "            \"textStyle\": {}\n",
       "        },\n",
       "        \"splitLine\": {\n",
       "            \"show\": true,\n",
       "            \"lineStyle\": {\n",
       "                \"width\": 1,\n",
       "                \"opacity\": 1,\n",
       "                \"curveness\": 0,\n",
       "                \"type\": \"solid\"\n",
       "            }\n",
       "        },\n",
       "        \"splitArea\": {\n",
       "            \"show\": true,\n",
       "            \"areaStyle\": {\n",
       "                \"opacity\": 0\n",
       "            }\n",
       "        },\n",
       "        \"axisLine\": {\n",
       "            \"show\": true,\n",
       "            \"onZero\": true,\n",
       "            \"onZeroAxisIndex\": 0\n",
       "        }\n",
       "    },\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"Radar-\\u57fa\\u672c\\u793a\\u4f8b\"\n",
       "        }\n",
       "    ]\n",
       "};\n",
       "        chart_f753508b08f1456fbb3f71abd982c0f2.setOption(option_f753508b08f1456fbb3f71abd982c0f2);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.render.display.HTML at 0x11a843b38>"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts.charts import Page, Radar\n",
    "\n",
    "col_radar = ['height','total_play', 'total_goal','total_assist']\n",
    "ranaldo = goal_analyse[col_radar].loc[2208]\n",
    "\n",
    "c = (\n",
    "        Radar()\n",
    "        .add_schema(\n",
    "            schema=[\n",
    "                opts.RadarIndicatorItem(name=\"身高\", max_=200),\n",
    "                opts.RadarIndicatorItem(name=\"出场次数\", max_=800),\n",
    "                opts.RadarIndicatorItem(name=\"进球数\", max_=600),\n",
    "                opts.RadarIndicatorItem(name=\"助攻数\", max_=240),\n",
    "                opts.RadarIndicatorItem(name=\"冠军数\", max_=50)\n",
    "            ]\n",
    "        )\n",
    "        .add(\"C罗\", [[184,800,600,213,38]], color=\"#f9713c\")\n",
    "        .add(\"梅西\", [[169,682,598,240,43]], color=\"#b9e4a1\")\n",
    "        .add(\"武磊\", [[174,233,123,67,5]], color=\"#a9713c\")\n",
    "        .set_series_opts(label_opts=opts.LabelOpts(is_show=False))\n",
    "        .set_global_opts(title_opts=opts.TitleOpts(title=\"Radar-基本示例\"))\n",
    "    )\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [],
   "source": [
    "col_radar = ['height','total_play', 'total_goal','total_assist']\n",
    "ranaldo = goal_analyse.loc[2208][col_radar]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "height          187\n",
       "total_play      800\n",
       "total_goal      600\n",
       "total_assist    213\n",
       "Name: 2208, dtype: object"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "goal_analyse.loc[2208][col_radar]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 20 entries, 2208 to 2305\n",
      "Data columns (total 4 columns):\n",
      "height          20 non-null object\n",
      "total_play      20 non-null int64\n",
      "total_goal      20 non-null int64\n",
      "total_assist    20 non-null int64\n",
      "dtypes: int64(3), object(1)\n",
      "memory usage: 1.4+ KB\n"
     ]
    }
   ],
   "source": [
    "#身高改成int类型\n",
    "goal_analyse[col_radar].height.astype('int')\n",
    "goal_analyse[col_radar].info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "invalid literal for int() with base 10: '-'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-182-a51310c6323b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'height'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mastype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'int'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'height'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/util/_decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    175\u001b[0m                 \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    176\u001b[0m                     \u001b[0mkwargs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mnew_arg_name\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnew_arg_value\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 177\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    178\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mwrapper\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    179\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0m_deprecate_kwarg\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mastype\u001b[0;34m(self, dtype, copy, errors, **kwargs)\u001b[0m\n\u001b[1;32m   4995\u001b[0m             \u001b[0;31m# else, only a single dtype is given\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4996\u001b[0m             new_data = self._data.astype(dtype=dtype, copy=copy, errors=errors,\n\u001b[0;32m-> 4997\u001b[0;31m                                          **kwargs)\n\u001b[0m\u001b[1;32m   4998\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_constructor\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnew_data\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__finalize__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4999\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36mastype\u001b[0;34m(self, dtype, **kwargs)\u001b[0m\n\u001b[1;32m   3712\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3713\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mastype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3714\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mapply\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'astype'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3715\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3716\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mconvert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36mapply\u001b[0;34m(self, f, axes, filter, do_integrity_check, consolidate, **kwargs)\u001b[0m\n\u001b[1;32m   3579\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3580\u001b[0m             \u001b[0mkwargs\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'mgr'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3581\u001b[0;31m             \u001b[0mapplied\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mb\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3582\u001b[0m             \u001b[0mresult_blocks\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_extend_blocks\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mapplied\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mresult_blocks\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3583\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36mastype\u001b[0;34m(self, dtype, copy, errors, values, **kwargs)\u001b[0m\n\u001b[1;32m    573\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mastype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mFalse\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'raise'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    574\u001b[0m         return self._astype(dtype, copy=copy, errors=errors, values=values,\n\u001b[0;32m--> 575\u001b[0;31m                             **kwargs)\n\u001b[0m\u001b[1;32m    576\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    577\u001b[0m     def _astype(self, dtype, copy=False, errors='raise', values=None,\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/internals.py\u001b[0m in \u001b[0;36m_astype\u001b[0;34m(self, dtype, copy, errors, values, klass, mgr, **kwargs)\u001b[0m\n\u001b[1;32m    662\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    663\u001b[0m                 \u001b[0;31m# _astype_nansafe works fine with 1-d only\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 664\u001b[0;31m                 \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mastype_nansafe\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mravel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    665\u001b[0m                 \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreshape\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    666\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/dtypes/cast.py\u001b[0m in \u001b[0;36mastype_nansafe\u001b[0;34m(arr, dtype, copy)\u001b[0m\n\u001b[1;32m    707\u001b[0m         \u001b[0;31m# work around NumPy brokenness, #1987\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    708\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0missubdtype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdtype\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minteger\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 709\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mlib\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mastype_intsafe\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0marr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mravel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreshape\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0marr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshape\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    710\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    711\u001b[0m         \u001b[0;31m# if we have a datetime/timedelta array of objects\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/lib.pyx\u001b[0m in \u001b[0;36mpandas._libs.lib.astype_intsafe\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/src/util.pxd\u001b[0m in \u001b[0;36mutil.set_value_at_unsafe\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: invalid literal for int() with base 10: '-'"
     ]
    }
   ],
   "source": [
    "data['height'].astype('int')\n",
    "data['height']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
